ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Userform, multipage, select a tab (https://www.excelbanter.com/excel-programming/324219-userform-multipage-select-tab.html)

Jos Vens[_2_]

Userform, multipage, select a tab
 
Hi,

how can I select a certain tab in my multipage object in the Userform
initialize section?

Libra_FrmParameters.mpParameters.tLibra.Select
Libra_FrmParameters.mpParameters.tLibra.Activate

both doesn't work

Thanks
Jos




Bob Phillips[_6_]

Userform, multipage, select a tab
 
Jos,

You need to set the value property to the page index (less 1, 0 based)

Me.MultiPage1.Value = 2

as an example sets Page3

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jos Vens" wrote in message
...
Hi,

how can I select a certain tab in my multipage object in the Userform
initialize section?

Libra_FrmParameters.mpParameters.tLibra.Select
Libra_FrmParameters.mpParameters.tLibra.Activate

both doesn't work

Thanks
Jos






Jos Vens[_2_]

Userform, multipage, select a tab
 
Thanks a lot Bob,

Jos

"Bob Phillips" schreef in bericht
...
Jos,

You need to set the value property to the page index (less 1, 0 based)

Me.MultiPage1.Value = 2

as an example sets Page3

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jos Vens" wrote in message
...
Hi,

how can I select a certain tab in my multipage object in the Userform
initialize section?

Libra_FrmParameters.mpParameters.tLibra.Select
Libra_FrmParameters.mpParameters.tLibra.Activate

both doesn't work

Thanks
Jos









All times are GMT +1. The time now is 07:08 AM.

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