user form tabs

[Carrie_Loos via OfficeKB.com]

Hi - I am trying to find how to clarify what tab to show when I show the
userform. For instance, on on tab when a control is clicked a macro goes
through an iteration and the last line of code is UserForm.Show but how do I
write it so that the UserForm shows as well as a specific tab within the user
form?

Thanks in advance
Carrie

 

[Jim Cone]

You didn't say which control you are using...MultiPage or Tab Control?
The .Value property determines which page or tab shows.
The syntax is the same...
Me.MultiPage1.Value = 0
Me.TabStrip1.Value = 1
Zero is the first page/tab with 1 the next page/tab etc.
All of the above is found in the Excel VBA help file.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Carrie_Loos via OfficeKB.com"
wrote in message
Hi - I am trying to find how to clarify what tab to show when I show the
userform. For instance, on on tab when a control is clicked a macro goes
through an iteration and the last line of code is UserForm.Show but how do I
write it so that the UserForm shows as well as a specific tab within the user
form?
Thanks in advance
Carrie

 

[Carrie_Loos via OfficeKB.com]

Thank you Jim and I did look in help for some time but could not find my
answer. Perhaps helps is written for those who know what nomenclature to
enter and not a generalist?