PDA

View Full Version : [SOLVED] Userform unload issue



nikki333
02-25-2019, 03:13 PM
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?

Paul_Hossler
02-25-2019, 03:38 PM
Leave the Userform loaded and use the "
UserForm_Activate" event