View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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