View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Michael Harrer Michael Harrer is offline
external usenet poster
 
Posts: 2
Default 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/