ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   MultiPage (https://www.excelbanter.com/excel-programming/350392-multipage.html)

Bill[_30_]

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



Chip Pearson

MultiPage
 
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" wrote in message
ink.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





All times are GMT +1. The time now is 02:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com