View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Benjamin Benjamin is offline
external usenet poster
 
Posts: 102
Default 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?