Excel Programming

[hass0002]

Hi,
Does anyone know where I can find some good resources for doing some programming within Excel?
Just to give you an Idea of what is going on, I have a spread sheet and I want to add a search tool that will let the user enter a search key and then press "Find" then the results will be highlighted. I'm not sure where to start.
Thanks.

[Cobra]

Go to references - add microsoft excel 8 lib. press f2 and you can browse thorugh the methods and properties of workbooks and worksheets. Then you can right click on them and go to help - they have very good examples there. I found everything that i wanted there.

[LittleJonny]

I am doing a search for duplicate entries in adjacent cells. You could scab some of this for what you are trying to do.

keep me posted I have some search code but cannot find in now.

LJ

Public Function FindDupAddresses()
k = 0
xlsWWDB.Worksheets("Discrete IO").Select
i = 1
While Cells(i, 14) <> ""
If Cells(i, 16) = Cells(i + 1, 16) Then
Cells(i, 16).Interior.ColorIndex = 3
Cells(i + 1, 16).Interior.ColorIndex = 3
k = k + 1
Else
End If
i = i + 1
Wend
xlsWWDB.Worksheets("Real IO").Select
i = 1
While Cells(i, 43) <> ""
If Cells(i, 45) = Cells(i + 1, 45) Then
Cells(i, 45).Interior.ColorIndex = 3
Cells(i + 1, 45).Interior.ColorIndex = 3
k = k + 1
Else
End If
i = i + 1
Wend
xlsWWDB.Worksheets("Integer IO").Select
i = 1
While Cells(i, 43) <> ""
If Cells(i, 45) = Cells(i + 1, 45) Then
Cells(i, 45).Interior.ColorIndex = 3
Cells(i + 1, 45).Interior.ColorIndex = 3
k = k + 1
Else
End If
i = i + 1
Wend
txtNoOfDupAddresses = k
End Function

[RGregoire]

Its been awhile since I've done any Excel programming but you might want to check out the MATCH function in Excel.

I can remember using it to search and find a value I needed in a list. I believe it returns the cell coordinates of the matching value.

Anyway check it out, it might be what you're looking for.