Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching and editing data with VBA
Hi All,
I have a sheet that has info in it such as first name, last name, email, location, and so on. I have made a form that helps the user fill in this info, and would now like to make a form(or use current) with a list or combo box that will show all the last and first names, then when one is choosen it fills in the rest of the data (email, location) into text boxes, so that the user can edit and save the data. I would appreciate any help on this or an alternative method of doing this. Thanks Jay |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching and editing data with VBA
Create your form (or modify the one you have) to contain a combo box.
Use the form initialize function to read in all the names from the worksheet into the combo box. Then use the combo box change event to find that person on your worksheet and read the info into the appropriate fields. wrote: Hi All, I have a sheet that has info in it such as first name, last name, email, location, and so on. I have made a form that helps the user fill in this info, and would now like to make a form(or use current) with a list or combo box that will show all the last and first names, then when one is choosen it fills in the rest of the data (email, location) into text boxes, so that the user can edit and save the data. I would appreciate any help on this or an alternative method of doing this. Thanks Jay |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching and editing data with VBA
I'm sorry, I need to be more specific I need help with the code.
Jay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching data | Excel Discussion (Misc queries) | |||
Searching for data | Excel Worksheet Functions | |||
Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
Searching for Data | Setting up and Configuration of Excel | |||
Searching Data | Excel Programming |