View Full Version : UserForm ComboBox

02-24-2009, 01:24 PM

I have a userform with a combobox on it with the rowsource set to sheet2!a1:a3. When the user selects from the drop down in the form, sheet2!A1 changes to their selection. Then the next time the userform is opened the dropdown options have changed to what was last selected. How can I get around this?


Bob Phillips
02-24-2009, 01:46 PM
Unload the form, don't hide it, or reset it in the activate event.

Kenneth Hobs
02-24-2009, 02:58 PM
I don't see that happening. Maybe you set the ControlSource?

02-24-2009, 03:06 PM
No, it is the rowsource = sheet2!a1:a3.

Kenneth Hobs
02-24-2009, 03:56 PM
Did you check the ControlSource property?

I have not seen that behaviour in 2003. Maybe you can post and xls that does it?