Find Record in exel worksheet from UserForm

  • Thread starter Thread starter bye4nowjb
  • Start date Start date
B

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
 
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.
 
Back
Top