Tab pages in a UserForm1 in VBA

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?
 
B

Benjamin

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

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

Found it!
 
K

ker_01

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top