vba - using multipage

[ajliaks]

Hi all,

I am using a multipage.
When I choose page2 in multipage, I want to show the messag
"Activating Page 2".

I am trying something like this, but I get error:

Private sub Multipage1_Change
if multipage.page.item ("Page2) = true then
msgbox "Activating Page 2"
end if
End sub

Thanks in advance.
Aldo

 

[papou]

Hello Alod
MsgBox "Activating page " & MultiPage1.Value + 1

HTH
Cordially
Pascal

 

[Harald Staff]

Private Sub MultiPage1_Change()
Me.Caption = "Activating " & _
MultiPage1.Pages(MultiPage1.Value).Caption
End Sub

HTH. Best wishes Harald

 

[Michael Harrer]

Hi Aldo,

try this:

Private Sub Multipage1_Change
'the .Value property of Multipage object start from 0 (=first page)
if Me.Multipage1.Value = 1 Then MsgBox "Activating Page 2"
End sub

Greetings,
Michael