ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Initialization using Multipage Tab (https://www.excelbanter.com/excel-programming/403969-initialization-using-multipage-tab.html)

WLMPilot

Initialization using Multipage Tab
 
I am using Multipage Tabbing for the first time. I want to initialize the
form on page 1. I know how to initialize a userform. Does it change when
using Multipage Tabbing?

Thanks,
Les

Chip Pearson

Initialization using Multipage Tab
 
Set the Value property of the Multipage control to the tab index you want to
display. The Index is 0-based: 0 = first page, 1 = second page, etc.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)

"WLMPilot" wrote in message
...
I am using Multipage Tabbing for the first time. I want to initialize the
form on page 1. I know how to initialize a userform. Does it change when
using Multipage Tabbing?

Thanks,
Les




WLMPilot

Initialization using Multipage Tab
 
I am new to this. I don't quite follow. I know the following is what is
used for initializing a userform. How do I do what you are describing?

Private Sub UserForm_Initialize()
End Sub

Les

"Chip Pearson" wrote:

Set the Value property of the Multipage control to the tab index you want to
display. The Index is 0-based: 0 = first page, 1 = second page, etc.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)

"WLMPilot" wrote in message
...
I am using Multipage Tabbing for the first time. I want to initialize the
form on page 1. I know how to initialize a userform. Does it change when
using Multipage Tabbing?

Thanks,
Les





TWR

Initialization using Multipage Tab
 
I think what Chip is trying to say is

Private Sub UserForm_Initialize()
MultiPage1.value=0 assuming you want the first page to be the one
visible.
End Sub



"WLMPilot" wrote:

I am using Multipage Tabbing for the first time. I want to initialize the
form on page 1. I know how to initialize a userform. Does it change when
using Multipage Tabbing?

Thanks,
Les


WLMPilot

Initialization using Multipage Tab
 
Thanks, I will give this a shot.

Les

"TWR" wrote:

I think what Chip is trying to say is

Private Sub UserForm_Initialize()
MultiPage1.value=0 assuming you want the first page to be the one
visible.
End Sub



"WLMPilot" wrote:

I am using Multipage Tabbing for the first time. I want to initialize the
form on page 1. I know how to initialize a userform. Does it change when
using Multipage Tabbing?

Thanks,
Les



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

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