Search Prog For Excel Sheet

[mrwoll]

This might be a easy question but I am a noob to VB so bare with me.

What i have is a list of items in Excel which I want to be able to search through. By this i mean i want a VB window to pop up to ask for a name which it will then search for in the list in Excel.
I have VB 6.3.

Can anyone start me off with some code or some idea of how to go about it?

[Muddy]

Originally posted by mrwoll
This might be a easy question but I am a noob to VB so bare with me.

What i have is a list of items in Excel which I want to be able to search through. By this i mean i want a VB window to pop up to ask for a name which it will then search for in the list in Excel.
I have VB 6.3.

Can anyone start me off with some code or some idea of how to go about it?
Record an Excel macro of a search to get an idea of what the code should look like.
Then early bind (set a reference with IDE menu options) or late bind (CreateObject) to Excel and use the code you recorded.
you can search the forums ... there are tons of specific examples of Excel automation ...