ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   can you set a default page in a Multipage userform? (https://www.excelbanter.com/excel-programming/358014-can-you-set-default-page-multipage-userform.html)

Trefor

can you set a default page in a Multipage userform?
 

I open a Userform where I have used Multipage, but every time I run the form
it seems to come up on a different Page to the one I would like to select, is
it possible to set a page as default?

--
Trefor

Jim Rech

can you set a default page in a Multipage userform?
 
Use MultiPage1.Value = 0 to open to the first page, 1 for the second, etc.

I'd put this code in Sub UserForm_Initialize

--
Jim
"Trefor" wrote in message
...
|
| I open a Userform where I have used Multipage, but every time I run the
form
| it seems to come up on a different Page to the one I would like to select,
is
| it possible to set a page as default?
|
| --
| Trefor



Trefor

can you set a default page in a Multipage userform?
 
Jim, excellent, thanks.
--
Trefor


"Jim Rech" wrote:

Use MultiPage1.Value = 0 to open to the first page, 1 for the second, etc.

I'd put this code in Sub UserForm_Initialize

--
Jim
"Trefor" wrote in message
...
|
| I open a Userform where I have used Multipage, but every time I run the
form
| it seems to come up on a different Page to the one I would like to select,
is
| it possible to set a page as default?
|
| --
| Trefor





All times are GMT +1. The time now is 10:39 AM.

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