Sharid
Well-known Member
- Joined
- Apr 22, 2007
- Messages
- 1,064
- Office Version
- 2016
- Platform
- Windows
Hi
I have a userform (Userform1) on it i have a multipage with tabs. When the userform opens all tabs except 1 is visible
I have command buttons on the userform, so if command button 2 is clicked then the second tab, which is Pages.(1) will show and the others including the first will be set to false
My problem is that all the textboxes and buttons etc. on the pages DO NOT show until i click the tab, Is there another way I can do this
I have a userform (Userform1) on it i have a multipage with tabs. When the userform opens all tabs except 1 is visible
VBA Code:
Private Sub UserForm_Initialize()
Me.MultiPage1.Pages(0).Visible = True
Me.MultiPage1.Pages(1).Visible = False
Me.MultiPage1.Pages(2).Visible = False
Me.MultiPage1.Pages(3).Visible = False
End Sub
I have command buttons on the userform, so if command button 2 is clicked then the second tab, which is Pages.(1) will show and the others including the first will be set to false
VBA Code:
Private Sub CommandButton2_Click()
Me.MultiPage1.Pages(0).Visible = False
Me.MultiPage1.Pages(1).Visible = True
Me.MultiPage1.Pages(2).Visible = False
Me.MultiPage1.Pages(3).Visible = False
End Sub
My problem is that all the textboxes and buttons etc. on the pages DO NOT show until i click the tab, Is there another way I can do this