abdelfattah
Well-known Member
- Joined
- May 3, 2019
- Messages
- 1,494
- Office Version
- 2019
- 2010
- Platform
- Windows
Hi Guys ,
I suspect this way is possible before I post my subject !
What I look for it hide bar of tabs for multipage without hide contents each tab(comboboxes, textboxes labels....)
my goal I don't want the user select each tab for multipage on userform when run the userform
so when press command button should select specific tab from the code inside .
In fact, the tabs are exist, but they should not appear to the user when run the userform . The tab bar must be hidden without hiding the content of each tab. The user will not be able to move from one tab to another when run the userform except by pressing one of the buttons by selecting a specific tab as it is found in each control button.
here is my buttons
I will be grateful if anybody could achieve it .
I suspect this way is possible before I post my subject !
What I look for it hide bar of tabs for multipage without hide contents each tab(comboboxes, textboxes labels....)
my goal I don't want the user select each tab for multipage on userform when run the userform
so when press command button should select specific tab from the code inside .
In fact, the tabs are exist, but they should not appear to the user when run the userform . The tab bar must be hidden without hiding the content of each tab. The user will not be able to move from one tab to another when run the userform except by pressing one of the buttons by selecting a specific tab as it is found in each control button.
here is my buttons
VBA Code:
Private Sub CommandButton1_Click()
UserForm1.MultiPage1.Value = 0
UserForm1.Show
Me.MultiPage1.Pages(0).Visible = False
End Sub
Private Sub CommandButton2_Click()
UserForm1.MultiPage1.Value = 1
UserForm1.Show
Me.MultiPage1.Pages(1).Visible = False
End Sub
Private Sub CommandButton3_Click()
UserForm1.MultiPage1.Value = 2
UserForm1.Show
Me.MultiPage1.Pages(2).Visible = False
End Sub