Tab pages in a UserForm1 in VBA

  • Thread starter Thread starter Benjamin
  • Start date Start date
B

Benjamin

I need to tab between pages in a multipage form, not a spreadsheet, but a
form I create in VBE. I'd like to link buttons on an Index tab to an
operations tab in that same multipage window but different tab. Anyone now
the object, or place to start, I'm just sure I could do it in Visual Studio,
but they won't let us use visual studio here. Any ideas?
 
Private Sub cmdBack_click()
MultiPage1.Value = MultiPage1.Value - 1
End Sub

Private Sub cmdNext_click()
MultiPage1.Value = MultiPage1.Value + 1
End Sub

Found it!
 
Be sure to put an IF statement in with your lowest/highest value for your
tabs, otherwise your user(s) will get an error when the code tries to push
them below or above your last sheets
:)
 
Back
Top