Module, UserForm, & MultiPage Managment

[Rufus Clupea]

I'm working on a fairly large (for me) project, using one (main) UserForm with a MultiPage. I was working under the mistaken belief that,

"A single VBA module can store any number of Sub procedures, Function procedures, and Declarations."
—Excel VBA Programming for Dummies

So most everything went into the UserForm Module. Things were going pretty well until I noticed the "fine print",

"Well, there is a limit—about 64,000 characters per module....the solution is simple: Just insert a new module."
—Ibid.

Ummm... right.

When I saw that qualifier, I copied my code into Word for a quick character count—it was something over 75,000 characters, and I knew I was only about 1/3 to 1/2 way along, so I split things into several modules, believing—as the book said—it would be "simple". That's where....

So I'm now engaged in probably one of many major re-writes (which is fine—I expected this ) Good time, methinks, to ask a few questions that have been collecting...

1. Is there any way of (globally?) telling modules that they're all part of the same project, and avoiding having to re-code everything with a "UserForm1." prefix (I'm using WITH-END WITH, but there's a LOT of stuff to account for)?
2. Is there a way to tab (key) directly from the last TabStop on one page of the MultiPage to the first TabStop on the next page without manually clicking on the MultiPage tab and the first TabStop on each subsequent page?
3. CheckBoxes have Captions; OptionButtons have Captions. Is there an easy way to combine a SpinButton with a Label (thereby giving it a "Caption"), or must I create a whole new object? (Not sure exactly how to do that yet, but willing to learn!)

TYA

https://www.youtube.com/watch?v=BxacATCHrpo

 

[Kyle123]

I've explained the concept of the code recently here: https://www.excelforum.com/excel-pr...timize-button-generator-code.html#post5085431 See if that makes it any clearer.

BTW yes, that's all the code does, puts three spinners on a userform with linked labels and increments them without duplicating the code

 

[Rufus Clupea]

I've explained the concept of the code recently here: https://www.excelforum.com/excel-pr...timize-button-generator-code.html#post5085431 See if that makes it any clearer.

Can you follow that? Or have I been clear as mud? haha

Mmmmm... Good question! From what I've been able to follow (so far), it may have some application in attaching a Label to a SpinButton, but I cannot (yet) see how it would...

...figure out what kind of Control it had been sent, and then [... allow me to] send the pertinent information to Subs for processing the respective Controls? This would (theoretically) allow me to use one Control naming/numbering scheme rather than different naming/numbering for each flavor of Control.

I think I may be on to something with User-Defined Date Types (they used to be called Records back in my C-64 days). Not positive, but reading & experimenting will likely keep me occupied for a bit...

Also, after looking ahead to see if/how I could apply your example... I realized the next group (couple-three hundred) SpinButton/Label combinations need to be <s>somewhat</s> quite different from the first 72, so I need to give this a bit more thought...

I've copied your code & explanation into a (more readily accessible) text file that I can refer to & study as I'm learning more, so thank you again for that. I'm sure I'll be able to glean & adapt at some point.