User Form to execute search and return all values to the user form for editing

I have a user form that I created that allows the entry of employee information that is then saved to a worksheet. The fields are:
First Name
Last Name
Hire Date
Hourly Pay Rate
Title / Position
Mon Start
Mon End
(continues through Sun End)

I have attached a copy of the code for this user form.

I want to create a duplicate user form that will allow a search by employee first or last name and return all of the values for that employee from the worksheet back into the user form to edit any of the entries and use a Save Changes command button to return the changes back to the worksheet.

Also, if the search produces multiple matches, display First and Last name in a list to select the correct employee info to return.

Thanks in advance for your assistance and let me know if you need any other info.

Please Login or Register  to view this content.

Tom

We need a sample workbook. Be sure to use bogus info.

Also, if the search produces multiple matches

Be sure to include the duplicate names you're talking about.

OK, test this out.

I changed the first/last textboxes to comboboxes.