software

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

/OleTry

Multipage1.Value = 1

The index starts at 0, so that activates Page2.--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;OMquot; gt; wrote in message
...
gt; I need to control witch tab on a MultiPage that is active when a Userform
is
gt; loaded.
gt;
gt; I have 3 buttons on my Excel sheet each one runs a different macro, but
gt; loads the same Userform, (Userform contains a MultiPage with 3 tabs). Only
gt; difference in these 3 macros is that I would like each of them to control
gt; witch tab is to be activated on the MultiPage.
gt;
gt; I just don't know how
gt;
gt; Can anyone help
gt;
gt; /Ole
gt;
Thank you, solved my problem.
Have a nice week-end

/Ole

quot;Bob Phillipsquot; wrote:

gt; Try
gt;
gt; Multipage1.Value = 1
gt;
gt; The index starts at 0, so that activates Page2.
gt;
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;OMquot; gt; wrote in message
gt; ...
gt; gt; I need to control witch tab on a MultiPage that is active when a Userform
gt; is
gt; gt; loaded.
gt; gt;
gt; gt; I have 3 buttons on my Excel sheet each one runs a different macro, but
gt; gt; loads the same Userform, (Userform contains a MultiPage with 3 tabs). Only
gt; gt; difference in these 3 macros is that I would like each of them to control
gt; gt; witch tab is to be activated on the MultiPage.
gt; gt;
gt; gt; I just don't know how
gt; gt;
gt; gt; Can anyone help
gt; gt;
gt; gt; /Ole
gt; gt;
gt;
gt;
gt;