C Corey Mar 5, 2007 #1 How can you set (in Initialize Userform procedure) a Mulitpage to Display Tab1 instead of the previously view Tab ? Corey....
How can you set (in Initialize Userform procedure) a Mulitpage to Display Tab1 instead of the previously view Tab ? Corey....
C Chip Pearson Mar 5, 2007 #2 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, 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)
C Corey Mar 5, 2007 #3 thanks Chip 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)
thanks Chip 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)
