I have some odd behavior occuring with my UserForm.
I had inserted a ListBox into the UserForm, and I was re-positioning the control when...I don't know what happened...my finger slipped off the mouse, or something. But, the ListBox simply VANISHED!!
No problem, right?? I simply grabbed and inserted another control.
The NEW control is listed in the UserForm Properties as ListBox2...!!!
ListBox1 is NOWHERE TO BE FOUND...!!!
It's not listed in the UserForm Properties...(ListBox2 is there).
It's not visible on the UserForm, itself...(ListBox2 is).
I even looked in the Tab Order for the UserForm...again, ListBox2, but no ListBox1.
And get this...If I try to RENAME ListBox2 to ListBox1, I get an "ambiguous name" error.
Here's why this is a problem...
I have lots of Macros or Event Procedures written to perform actions with the items found in ListBox1 on all of my UserForms. I will have to re-write all of that code to make it work with this UserForm...
Or, I can re-build the UserForm from scratch...which is probably what I will end up doing.
So...here's my questions:
Does anybody have any idea what happened, here??
Have you ever experienced this before??
And, if so...do you know how to fix it without scrapping the UserForm??
I spent a while searching for the solution on the internet...and couldn't even find anyone that had experienced a similar situation.
Any insight would be greatly appreciated.
Bookmarks