Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 470
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 470
Default 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




  #4   Report Post  
Posted to microsoft.public.excel.programming
TWR TWR is offline
external usenet poster
 
Posts: 30
Default 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

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 470
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Initialization adewole Excel Programming 0 July 31st 07 04:14 PM
initialization of an array???? Barb Excel Programming 3 July 13th 07 12:51 PM
UserForm Initialization Patrick Simonds Excel Programming 1 January 21st 05 02:40 AM
Userform Initialization Patrick Simonds Excel Programming 2 May 22nd 04 10:17 PM
List box initialization Daniel Thompson Excel Programming 0 July 15th 03 05:17 PM


All times are GMT +1. The time now is 12:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"