Hi Folks
I'm trying to implement a userform that upon activating highlights the text in one of it's comboboxes. This works well, when the "UserForm_Initialize" event is called. However, the said event doesn't get called most of the time.
I'm using a "hide" statement after the form has done it's job. But when using a "show" statement" afterwards, the initializing is not being called anymore.
What I read is that I should use an "unload" statement (instead of "hide"), but whereever I try to put this, I get an error. Likewise for a "load" statement (instead of "show").
Regardless of this, whenever the "UserForm_Initialize" gets called, it ignores to highlight the Combobox Text; however the "Combobox_Change" Event does it, and the code is exactly the same.
Any ideas?
Reply With Quote
