Multipage question
 

Good afternoon all,

I have a userform that uses a multipage control. There are 5 pages
included. On the first page, users will have a few options to select
from. Based on their selections, the users will have to enter
information on certain pages of the other four. To prevent users from
entering information on the incorrect page, I was wondering if there is
a way to deactivate, i.e. prevent users from selecting, certain pages.

I know that I could do this with a series of userforms instead of the
multipage control but I was just hoping I could use the multipage
control to keep everything contained in the one form.

Any ideas?
Cheers
dw


--
toocold
------------------------------------------------------------------------
toocold's Profile: http://www.excelforum.com/member.php...o&userid=31608
View this thread: http://www.excelforum.com/showthread...hreadid=533829

Multipage question
 

You can use the Enabled property. E.g.,

Me.MultiPage1.Pages(0).Enabled = False

Pages are numbered starting at zero up to PageCount - 1.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"toocold"
wrote in message
...

Good afternoon all,

I have a userform that uses a multipage control. There are 5
pages
included. On the first page, users will have a few options to
select
from. Based on their selections, the users will have to enter
information on certain pages of the other four. To prevent
users from
entering information on the incorrect page, I was wondering if
there is
a way to deactivate, i.e. prevent users from selecting, certain
pages.

I know that I could do this with a series of userforms instead
of the
multipage control but I was just hoping I could use the
multipage
control to keep everything contained in the one form.

Any ideas?
Cheers
dw


--
toocold
------------------------------------------------------------------------
toocold's Profile:
http://www.excelforum.com/member.php...o&userid=31608
View this thread:
http://www.excelforum.com/showthread...hreadid=533829

Multipage question
 

Thanks Chip.

I figured it was something simple like that but I hadn't sorted it out.
It is working now.

Cheers,
dw


--
toocold
------------------------------------------------------------------------
toocold's Profile: http://www.excelforum.com/member.php...o&userid=31608
View this thread: http://www.excelforum.com/showthread...hreadid=533829