Text box Exits running when form closes - can this be presented

[brucemc777]

Is there a way to prevent all of the textbox exit procedures from running when I unload a form?

[LJMetzger]

Hi Bruce,

Unfortunately, there is no Application.EnableEvents equivalent for UserForms. You can however create your own. The following code had not been tested.

In an ordinary code module:

Please Login or Register  to view this content.

In the UserForm module, for each Event that you may want inhibited you need code like:

Please Login or Register  to view this content.

I hope this helps.

Lewis

[brucemc777]

Well, on one hand that sure was a PITA, but on the other, the best solution available; Thank-You for coming to my help!!!

[brucemc777]

In my roughly 36 years of dabbling with Excel & prior Lotus, I never ventured into Class Modules. Would something like what is presented here have been a possible option?