Cycle through a MultiPage Control
 

Hello. I have a MultiPage control on a UserForm (in Excel) that
contains 6 pages. When the user presses the "Next" button on the form,
I would like them to be taken to the next page on the MultiPage
control.

I have tried several options, but I cannot get it to behave as desired.
Can anybody provide a workable solution at all please? Or should I be
using a TabStrip instead?

Thanks in advance,

Rob.

:confused:


--
RobEdgeler
------------------------------------------------------------------------
RobEdgeler's Profile: http://www.excelforum.com/member.php...o&userid=27336
View this thread: http://www.excelforum.com/showthread...hreadid=468970

Cycle through a MultiPage Control
 

Good evening RobEdgeler

Stick with the MultiPage - I find them easier to work with than the
TabStrip. Each tab in a multipage (say MultiPage1) has an index
number, starting at zero. So the line below attached to a button will
activate the second tab when clicked.

MultiPage1.Value = 1

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=468970

Cycle through a MultiPage Control
 

Great! Thanks very much for your help.

Rob

--
RobEdgele
-----------------------------------------------------------------------
RobEdgeler's Profile: http://www.excelforum.com/member.php...fo&userid=2733
View this thread: http://www.excelforum.com/showthread.php?threadid=46897