# Posts by Carim

• ## How tp sum the total cost for the specified item which is search by me

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

Hi,

You can test following ...

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

HTH

• ## VBA: Control buttons get wonky when moved (Mac)

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

• ## Insert space 10 chars from end of row within indiv cells containing many rows

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

• ## Search Sheet for Text in range, delete rows not containing the text

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...)

• ## Add specific text to text box, based on dropdown list choice

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 ...

• ## Formula to Calculate Distance Between Locations

Hi,

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

HTH

• ## Formula to Calculate Distance Between Locations

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

• ## Searching For Duplicates

Re: Searching For Duplicates

Hi,

Something along these lines ...

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

HTH
Carim

• ## Quotations And Similar Characters In Strings

Re: Quotations And Similar Characters In Strings

Hi,

Below is a tested code which works fine ...

Code
1. Sub Testsit()
2. Dim tempString As String
3. tempString = "\" & Chr(96) & """www.ozgrid.com""" & "\" & Chr(96)
4. Range("A1").Value = tempString
5. End Sub
• ## Quotations And Similar Characters In Strings

Re: Quotations And Similar Characters In Strings

Hi,

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

HTH
Carim

• ## Repeat Values Into A Column

Re: Repeat Values Into A Column

Stephen,

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

• ## Repeat Values Into A Column

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 ...

• ## Repeat Values Into A Column

Re: Repeat Values Into A Column

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

• ## Repeat Values Into A Column

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

## Files

• Repeats.zip