Search Box help??

[mler]

I am creating a price list in excel 2000 for distribution, and wa
wondering if there is a way to create a search box & button on the th
actual worlsheet, making it easy to find part & pricing? Just like
search on the web.

I know about the ctrl + F, but the people receiving the list may not.
So I have to keep it as simple as possible for them.

I've been searching for a few days for answers, but most don't appea
to be exactly what I'm looking for.

Sorry if this is a lame question, I'm fairly new to this, and trying t
learn. Thanks in advance

 

[Harald Staff]

Hi

1 Record a macro while you perform Excel's built-in Search.
2 Replace the "what" sting in the macro with Range("A1").Value (if A1 is
your search cell that is). Like

Cells.Find(What:=Range("A1").Value, After:=ActiveCell, _
LookIn:=xlFormulas, LookAt:= (... and so on, as recorded)

3 Put a button from the Forms toolbar next to the cell and assign your macro
to it (by righclick, "assign macro).

HTH. Best wishes Harald