vba - using multipage
 

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

--
Message posted from http://www.ExcelForum.com

vba - using multipage
 

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

HTH
Cordially
Pascal

"ajliaks " a écrit dans le message
de ...
Hi all,

I am using a multipage.
When I choose page2 in multipage, I want to show the message
"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.


---
Message posted from http://www.ExcelForum.com/

vba - using multipage
 

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

HTH. Best wishes Harald


"ajliaks " skrev i melding
...
Hi all,

I am using a multipage.
When I choose page2 in multipage, I want to show the message
"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.


---
Message posted from http://www.ExcelForum.com/

vba - using multipage
 

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

"ajliaks " schrieb im Newsbeitrag
...
Hi all,

I am using a multipage.
When I choose page2 in multipage, I want to show the message
"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.


---
Message posted from http://www.ExcelForum.com/