ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   multipage question (https://www.excelbanter.com/excel-programming/296213-multipage-question.html)

David Goodall

multipage question
 
Hi,
I've created a multipage form containing 10 pages and I'd like, if possible,
to be able to use label1_dblclick() on label1, page 1, which then
automatically open page 5 say. I'm trying to duplicate a sort of hyperlink.
I've looked through the multipage properties but I can't see show as one of
them.

Any help, as always greatly appreciated.

Thanks
David.





Bob Phillips[_6_]

multipage question
 
Hi David,

Private Sub Label1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
Me.MultiPage1.Value = 4
End Sub

You use the value 4 as the collection starts at 0.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"David Goodall" wrote in message
news:JXNic.58$1f2.32@newsfe1-win...
Hi,
I've created a multipage form containing 10 pages and I'd like, if

possible,
to be able to use label1_dblclick() on label1, page 1, which then
automatically open page 5 say. I'm trying to duplicate a sort of

hyperlink.
I've looked through the multipage properties but I can't see show as one

of
them.

Any help, as always greatly appreciated.

Thanks
David.








All times are GMT +1. The time now is 11:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com