Using a combobox without overwriting existing data

**pleiadeez7** · 10-09-2008, 10:15 PM

I have a worksheet containing employee information (i.e. name, manager, department, etc.). I also have a userform that will be used to make changes to the employee information. The userform has three comboboxes and, when activated, the userform is populated with the existing data in the worksheet.

Here is the problem - I need to have the existing worksheet data populate (as it does now) but also have the combobox choices available in the event that one of the 'combo' fields need to be changed. How do I keep the existing worksheet data AND keep the functionality of the combobox?

Does this make sense? I feel like I'm rambling!

**rylo** · 10-09-2008, 11:36 PM

Hi

Not really clear on what is being populated. Is it the comboboxes (in which case why isn't the data available in them), or do the selections from the comboboxes put the relevant data somewhere else on the form then clear out the comboboxes?

Maybe an example file to clarify your situation.

rylo

**pleiadeez7** · 10-10-2008, 10:48 AM

Hi rylo - thanks for getting back to me. A test spreadsheet is attached. Once you open the spreadsheet, go to VBA and the 'changeemployeeform' should be displayed. The form has three comboboxes; manager, status, and category. If you run the form you will see that the first employee in the list shows up in the userform minus the manager, status, and category fields. If you move the userform to see the data beneath you will see that the manager, status, and category fields for the existing employees have data that does not populate in the user form.

When the userform is activated I would like for it to display all data for each employee yet have the combobox options available in the event that the existing data needs to change.

I hope it will be clearer once you see the form run. =)

Thanks for taking a look!

Janet

**rylo** · 10-10-2008, 06:30 PM

Janet

In your code Sub UserForm_Activate add another row before the end

Please Login or Register  to view this content.

I've just followed your data loading process just to give you the idea. You have loaded the comboboxes with data, you just have to select the relevant item for the record selected.

HTH

rylo