Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What's the difference between 'Set UserForm1=Nothing' and 'Unload UserForm1' ? | Excel Programming | |||
UserForm1 not getting removed using VBA | Excel Programming | |||
Scrolling of UserForm1 | Excel Programming | |||
Userform1 Border | Excel Programming | |||
Userform1 Border | Excel Programming |