Problem with search code

Hey guys,
I have created a search field in the top of my excel spreadsheet with a list of a couple hundred names.

I created the search function and it all works great. Only problem I have is that I have to enter the value that is being searched for in the macro. So I put in a textbox next to the search button. So someone who searches can just enter the name in the box, hit the search button, thereby run the macro and then search the document. For some reason I can't seem to get it to work to take the value from the textbox to search though.

What am I doing wrong? can anyone help?

Thanks,
Alex

Please Login or Register  to view this content.

hi Alex,
try this

Please Login or Register  to view this content.

john

Hey John,
thanks a lot for the code. I've been playing with it for a bit trying to adjust it so it works for me.

However I keep getting the same error message saying Sub or Function not defined.

Any thoughts?

thanks,
alex

hi alex,
i use it and it works fine. sure u need to adjust it for yr needs.
john