MultiPage

Hello,
Need some help please. I have a userform with a multipage. When a
multipage (like the first one) is activated, I would like to enable parts of
the page. I can't seem to find the command to know when the multipage is
activated. Any suggestions?

Thanks,

Bill

The Change event occurs when a page is selected.

Private Sub MultiPage1_Change()
MsgBox Me.MultiPage1.Value
End Sub

Note that the Value is 0-based; the first page is 0, the second
page is 1, etc.


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




"Bill" <bill@bpiconsulting.com> wrote in message
news:bXTxf.7739$%W1.3916@newsread2.news.atl.earthlink.net...
> Hello,
> Need some help please. I have a userform with a multipage.
> When a multipage (like the first one) is activated, I would
> like to enable parts of the page. I can't seem to find the
> command to know when the multipage is activated. Any
> suggestions?
>
> Thanks,
>
> Bill
>

The Change event occurs when a page is selected.

Private Sub MultiPage1_Change()
MsgBox Me.MultiPage1.Value
End Sub

Note that the Value is 0-based; the first page is 0, the second
page is 1, etc.


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




"Bill" <bill@bpiconsulting.com> wrote in message
news:bXTxf.7739$%W1.3916@newsread2.news.atl.earthlink.net...
> Hello,
> Need some help please. I have a userform with a multipage.
> When a multipage (like the first one) is activated, I would
> like to enable parts of the page. I can't seem to find the
> command to know when the multipage is activated. Any
> suggestions?
>
> Thanks,
>
> Bill
>