ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multipage Object on User Form (https://www.excelbanter.com/excel-programming/283754-multipage-object-user-form.html)

Paul Cheers

Multipage Object on User Form
 
Hi,

Is it possible and what is the code to select a tab on a
multipage object on a userform? I have 6 different tabs
and want the ability to select different ones.

Not sure if it is possible, I have tried everything!!

Paul

Ron de Bruin

Multipage Object on User Form
 
Hi Paul

You need the value property

MultiPage1.Value = 0 will select the first page.

1 = page 2


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Paul Cheers" wrote in message ...
Hi,

Is it possible and what is the code to select a tab on a
multipage object on a userform? I have 6 different tabs
and want the ability to select different ones.

Not sure if it is possible, I have tried everything!!

Paul




Alex@JPCS

Multipage Object on User Form
 
Cheers, Paul

Try:

Me.MultiPage1.Value = 0 or Userform1.Multipage1.Value = 5
Page index starts at zero

Alex J

"Paul Cheers" wrote in message
...
Hi,

Is it possible and what is the code to select a tab on a
multipage object on a userform? I have 6 different tabs
and want the ability to select different ones.

Not sure if it is possible, I have tried everything!!

Paul





All times are GMT +1. The time now is 12:34 PM.

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