Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Strange userform behavior 1

Status
Not open for further replies.

RobBroekhuis

Technical User
Oct 15, 2001
1,971
US
In the Excel VBA project I'm working on, I've used userforms extensively, and have seen some odd behavior while manipulating them inside VBA. As a matter of fact, I suspect that some of this behavior is causing the GPF situation that I asked about in my previous post.
The problems always arise when I add a new control to a userform, or rename an existing control. Often, the userform code editor will then not recognize the new control (i.e., not offer it as a suggestion in its dropdown lists, not correct the upper/lower-case in references to it), and running the associated code will generate an error. Leaving and re-entering Excel typically corrects the problem. Is this a common thing, something wrong with my copy of Excel (2000, running on W95), or something I am doing wrong?
 
Actually I've run into the same situation with userforms. I don't know what causes it, but what worked for me was compiling the project right after adding the controls to the form. ----------------------------------------
If you are reading this, then you have read too far... :p

lightwarrior@hotmail.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top