Find Record in exel worksheet from UserForm
 

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

Find Record in exel worksheet from UserForm
 

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.

--
Regards,
Tom Ogilvy


"bye4nowjb" wrote:

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