Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Initialization | Excel Programming | |||
initialization of an array???? | Excel Programming | |||
UserForm Initialization | Excel Programming | |||
Userform Initialization | Excel Programming | |||
List box initialization | Excel Programming |