ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   activate a page of a Multipage in Userform (https://www.excelbanter.com/excel-discussion-misc-queries/176085-activate-page-multipage-userform.html)

Jeff

activate a page of a Multipage in Userform
 
Hi,

I have a userform that is activated when the worksheet opens. In the
Userform there is a "multipage" Page1 and Page2.

I want to activate Page1, but could not figure out how to do this.

In the properties panel

Name = Page1
Index = 1


I tried

Userform.multipage1.activate


Thanks for your help



Dave Peterson

activate a page of a Multipage in Userform
 
Me.MultiPage1.Value = 0
(0 is the first, 1 the second, ...)

Jeff wrote:

Hi,

I have a userform that is activated when the worksheet opens. In the
Userform there is a "multipage" Page1 and Page2.

I want to activate Page1, but could not figure out how to do this.

In the properties panel

Name = Page1
Index = 1

I tried

Userform.multipage1.activate

Thanks for your help


--

Dave Peterson


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

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