Find Record in exel worksheet from UserForm

[bye4nowjb]

I have created a Userform, and added an Inquiry button. I want to be able to
put in a Customer Name in my first field of the form, and click inquire to
pull up the record (all the fields on my form), form my excel spreadsheet.

I am new at this, so be gentle

 

[Tom Ogilvy]

This article shows the opposite:

http://support.microsoft.com/?id=213749

however, you would use the same concepts. Loop through the data or use the
Edit=>Find command (you can record a macro to get the syntax) to find you
value, then just test your textboxes to the values of the cells in that row.