Thread: MultiPage
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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