Hello!
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?
Thanks!
Unload the form, don't hide it, or reset it in the activate event.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I don't see that happening. Maybe you set the ControlSource?
No, it is the rowsource = sheet2!a1:a3.
Did you check the ControlSource property?
I have not seen that behaviour in 2003. Maybe you can post and xls that does it?
Posting Permissions
Reply With Quote
