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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBE Userform bug?

Status
Not open for further replies.

RobBroekhuis

Technical User
Oct 15, 2001
1,971
US
I've had a very consistent, very annoying problem for a long time now, relating to the VBE Userform definition functionality. When I first compose a userform, things work fine. When I later come in and add a control to a userform, that control somehow doesn't "take": when I double-click it, VBE takes me to the code sheet, but does not create the corresponding default event handler (e.g., btnOK_click). In the VBE property dropdowns, the control is missing. Worse, when I try to run, Excel becomes unstable, and I've had occasions where the entire workbook has become corrupted beyond repair.
My workaround has been to remove the userform after every change (and saying yes to the "export?" question), then to re-import the userform. That clears the problem right up, but is obviously cumbersome.
I've asked here about this problem before, about a year ago, with no response. Maybe somebody new around these parts has encountered this?
I'd appreciate any insights
Rob
[flowerface]
 
Rob, I have encountered this, so you aren't alone my friend...unfortunately our creative solutions are one and the same and I haven't a clue why, and its both very cubersome and frustrating to remedy. I have to concede I haven't encounter in a while however. [yinyang] Tranpkp [pc2]
************************************
- Let me know if this helped/worked!

Remember to give helpful posts the stars they deserve, this facilitates others navigating through the threads / posts!
 
Hmmm... I guess my Excel may be corrupted somehow. Too bad it's a pain (in my corporate environment) to get it reloaded.
Rob
[flowerface]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top