Multipage question

[toocold]

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

 

[Chip Pearson]

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" <[email protected]>
wrote in message
news:[email protected]...

 

[toocold]

Thanks Chip.

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

Cheers,
dw