Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MultiPage
I need to control witch tab on a MultiPage that is active when a Userform is
loaded. I have 3 buttons on my Excel sheet each one runs a different macro, but loads the same Userform, (Userform contains a MultiPage with 3 tabs). Only difference in these 3 macros is that I would like each of them to control witch tab is to be activated on the MultiPage. I just dont know how Can anyone help /Ole |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
MultiPage
Try
Multipage1.Value = 1 The index starts at 0, so that activates Page2. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "OM" wrote in message ... I need to control witch tab on a MultiPage that is active when a Userform is loaded. I have 3 buttons on my Excel sheet each one runs a different macro, but loads the same Userform, (Userform contains a MultiPage with 3 tabs). Only difference in these 3 macros is that I would like each of them to control witch tab is to be activated on the MultiPage. I just don't know how Can anyone help /Ole |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
MultiPage
Thank you, solved my problem.
Have a nice week-end /Ole "Bob Phillips" wrote: Try Multipage1.Value = 1 The index starts at 0, so that activates Page2. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "OM" wrote in message ... I need to control witch tab on a MultiPage that is active when a Userform is loaded. I have 3 buttons on my Excel sheet each one runs a different macro, but loads the same Userform, (Userform contains a MultiPage with 3 tabs). Only difference in these 3 macros is that I would like each of them to control witch tab is to be activated on the MultiPage. I just don't know how Can anyone help /Ole |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use multipage | Excel Discussion (Misc queries) | |||
How do I auto-save multipage report printing to Acrobat Distiller | Excel Discussion (Misc queries) |