Posts by Carim

Re: Updating worksheet based off listbox selection

Hi,

The solution is to use the row number of the selected record in order to add the specific info ...

Attaching your workbook would allow for a tailor-made solution ...

Re: Average of 3 weeks ending at specified Date column

Hello Roberta,

Attached is a proposal ... using your sample data ...

HTH

Re: VBA Hide rows based on drop down option

Hi,

Should you need just to clean your code ...

Sub Dropdown()
    If Range("F7") = "" Then
        Range("8:42,43:76,78:111,113:146,148:181").EntireRow.Hidden = True
        Range("f42").Value = ""
        Range("f77").Value = ""
        Range("f112").Value = ""
        Range("f147").Value = ""
    End If
     
    If Range("F7") = "Wolf Lord" Then
        Range("8,22:37").EntireRow.Hidden = False
        Range("9:21,38:41").EntireRow.Hidden = True
    End If
     
    If Range("G8") = "Runic Armour" Then
        Range("8:9,22:37").EntireRow.Hidden = False
        Range("9:21,38:41").EntireRow.Hidden = True
    End If
     
End Sub

HTH

Re: Worksheet with command button

Hello,

Rather strange ... there is no apparent reason for a Command Button not to moved ... once you have assigned a macro ...

Is it a Forms button or an ActiveX one ...?

Re: How tp sum the total cost for the specified item which is search by me

Hi,

You can test following ...

textbox2.value=Application.Sumif(Sheet1.range("A2:A7"),textbox1.value,Sheet1.range("C2:C7"))

HTH

Re: VBA: Control buttons get wonky when moved (Mac)

Hi,

Rather strange ...

Once you have your buttons in place, you could try to group them ... in order to avoid all the bizarre things you are describing ...

or add an event macro say Activate ... to correct all the strange modifications ...

HTH

Re: Insert space 10 chars from end of row within indiv cells containing many rows

Hi Jaffey,

Keeping all the rows in the same cell can make your life more complicated ...

Should you split in individual rows ... you could test following formula :

=LEFT(A1,LEN(A1)-12)&" Ph: "&RIGHT(A1,12)

HTH

Re: Search Sheet for Text in range, delete rows not containing the text

Hi Anne,

Why don't you attach your workbook ...in order to get a precise answer ... (much better than general comments on the feasibility...)

Re: Add specific text to text box, based on dropdown list choice

Hello Anne,

The beauty with Excel ... is that everything is possible ...

For a precise answer ... you will need to better specify your constraints ...

Re: I need some help please thanks in advance

Hi,

See attached test file ... using Chip's formula

HTH

Re: I need some help please thanks in advance

Hi,

There are many different solutions ... e.g. with latitude and longitude
Take a look at Chip's solutions : http://www.cpearson.com/excel/LatLong.aspx

HTH

Re: Sheet Numbering

Hi,

You could take a look at a free add-in called Excel Explosion, which does it all for you ...
http://www.datapigtechnologies.com/freeware.htm

HTH
Carim

Re: Searching For Duplicates

Hi,

Something along these lines ...

=IF(COUNTIF(ListA!$A$2:$A$20,A2)>0,A2,"")

HTH
Carim

Re: Quotations And Similar Characters In Strings

Hi,

Below is a tested code which works fine ...

Sub Testsit()
Dim tempString As String
tempString = "\" & Chr(96) & """www.ozgrid.com""" & "\" & Chr(96)
Range("A1").Value = tempString
End Sub

Re: Quotations And Similar Characters In Strings

Hi,

May be you could try concatenation with char(96) ...

HTH
Carim

Re: Repeat Values Into A Column

Stephen,

Thanks a LOT ... !!!
It is exactly what I was looking for ...
Cheers
Carim

Re: Repeat Values Into A Column

Thanks a lot Mac for the VBA solution which is working fine ...
But, for some distribution reason, I am looking for a Formula to replicate thr VBA code ...

Re: Repeat Values Into A Column

Thanks a lot for the VBA solution ...
but I am after a spreadsheet Formula ...

Hi,

I am looking for a formula to repeat a given set of values, a certain number of times ...
See attached for visual explanation ...

TIA