hide bar of tabs for multipage without hide contents of tabs on userform

abdelfattah

Well-known Member
Joined
May 3, 2019
Messages
1,494
Office Version
  1. 2019
  2. 2010
Platform
  1. 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
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
I will be grateful if anybody could achieve it .
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Forum statistics

Threads
1,223,879
Messages
6,175,142
Members
452,615
Latest member
bogeys2birdies

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top