Tab pages in a UserForm1 in VBA
 

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?

Tab pages in a UserForm1 in VBA
 

Private Sub cmdBack_click()
MultiPage1.Value = MultiPage1.Value - 1
End Sub

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

Found it!

"Benjamin" wrote:

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?

Tab pages in a UserForm1 in VBA
 

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
:)

"Benjamin" wrote:

Private Sub cmdBack_click()
MultiPage1.Value = MultiPage1.Value - 1
End Sub

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

Found it!

"Benjamin" wrote:

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?