ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multipage Tab's (https://www.excelbanter.com/excel-programming/384576-multipage-tabs.html)

Corey

Multipage Tab's
 
How can you set (in Initialize Userform procedure) a Mulitpage to Display Tab1 instead of the
previously view Tab ?

Corey....



Chip Pearson

Multipage Tab's
 
Corey,

Try something like

Private Sub UserForm_Activate()
Me.MultiPage1.Value = 0 ' 0 = first tab, 1 = second tab, etc
End Sub

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"Corey" wrote in message
...
How can you set (in Initialize Userform procedure) a Mulitpage to Display
Tab1 instead of the
previously view Tab ?

Corey....





Corey

Multipage Tab's
 
thanks Chip
"Chip Pearson" wrote in message ...
Corey,

Try something like

Private Sub UserForm_Activate()
Me.MultiPage1.Value = 0 ' 0 = first tab, 1 = second tab, etc
End Sub

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"Corey" wrote in message
...
How can you set (in Initialize Userform procedure) a Mulitpage to Display
Tab1 instead of the
previously view Tab ?

Corey....







All times are GMT +1. The time now is 02:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com