I have created a multipage userform with numerous textboxes, listboxes, and spin buttons, and the code has grown to over 2,500 lines. I tried to subdivide the code by placing part of the code into a separate module, but the usereform couldn't recognize it whether it was a private or public sub. Is there a way to split lengthy userform code into separate modules in order to organize it and make it more manageable?
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 sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Subdividing Userform Code
- Thread starter f64
- Start date
TonyJollans
Programmer
Hi f64,
You must have all the event procedures in the userform itself but there is no reason for them not to be able to call external procedures.
Enjoy,
Tony
--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[
You must have all the event procedures in the userform itself but there is no reason for them not to be able to call external procedures.
Enjoy,
Tony
--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question