Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MultiPage tab? | Excel Discussion (Misc queries) | |||
Multipage | Excel Programming | |||
Multipage | Excel Programming | |||
MultiPage | Excel Programming | |||
Multipage | Excel Programming |