Macro to search a name list from what you type in

[johnandrews]

Hi all, I may have touched on this subject before. Now I have a clearer idea what I'm trying to obtain.

I'm attempting to set up a search as follows:

There are a list of 2,000 records headed by one of 92 different names. I'm trying to make a text box which lets them search for whatever they type in. Hit 'search' you get all the dozens of records pertaining to the entered name; and with a 'reset' button. Good idea for later is for the text box to default to whatever the user's real name is.

I'll try and upload a mockup.

[Kenneth Hobson]

You should probably use Environ("username") rather than Application.Name for your textbox1 initial value.

Please Login or Register  to view this content.