W
WLMPilot
I have two books on Excel VBA and have googled "Multipage Tab" and I am still
in the dark about how to set things up when using this feature. I have
already set up a userform using page1.
The only reference I have made to page1 in my code is below:
Private Sub UserForm_Initialize()
MultiPage1.Value = 0
There is no other reference made anywhere. As best as I can tell, all pages
would be initialized in this section. My code works fine, but I am at a lost
when I start to design other pages. I noticed when I view code from page2,
that all the code from page1 is brought up. Thus my confusion as to how it
is kept separate. Maybe only because the textboxes, combo/Listboxes, etc
will increment. I assume I will not have a textbox1 on both pages.
My question is where and when are references needed regarding multipage
tabbing and how is code like "MultiPage1.Value = 0" used?
Thanks,
Les
in the dark about how to set things up when using this feature. I have
already set up a userform using page1.
The only reference I have made to page1 in my code is below:
Private Sub UserForm_Initialize()
MultiPage1.Value = 0
There is no other reference made anywhere. As best as I can tell, all pages
would be initialized in this section. My code works fine, but I am at a lost
when I start to design other pages. I noticed when I view code from page2,
that all the code from page1 is brought up. Thus my confusion as to how it
is kept separate. Maybe only because the textboxes, combo/Listboxes, etc
will increment. I assume I will not have a textbox1 on both pages.
My question is where and when are references needed regarding multipage
tabbing and how is code like "MultiPage1.Value = 0" used?
Thanks,
Les