Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find record by multi criteria in userform | Excel Discussion (Misc queries) | |||
VBA: Pull Record Into UserForm | Excel Programming | |||
VBA: Pull Record Into UserForm | Excel Programming | |||
exel macro to eliminate duplicate record | Excel Programming | |||
Exel VBA- userform startup problem | Excel Programming |