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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200802/1

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

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?

Jim Cone wrote:
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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200802/1