Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Multipage Object on User Form

Hi,

Is it possible and what is the code to select a tab on a
multipage object on a userform? I have 6 different tabs
and want the ability to select different ones.

Not sure if it is possible, I have tried everything!!

Paul
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Multipage Object on User Form

Hi Paul

You need the value property

MultiPage1.Value = 0 will select the first page.

1 = page 2


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Paul Cheers" wrote in message ...
Hi,

Is it possible and what is the code to select a tab on a
multipage object on a userform? I have 6 different tabs
and want the ability to select different ones.

Not sure if it is possible, I have tried everything!!

Paul



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 33
Default Multipage Object on User Form

Cheers, Paul

Try:

Me.MultiPage1.Value = 0 or Userform1.Multipage1.Value = 5
Page index starts at zero

Alex J

"Paul Cheers" wrote in message
...
Hi,

Is it possible and what is the code to select a tab on a
multipage object on a userform? I have 6 different tabs
and want the ability to select different ones.

Not sure if it is possible, I have tried everything!!

Paul



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
MultiPage Form Question NFL Excel Discussion (Misc queries) 4 December 30th 09 02:21 PM
How do I fill a cell in a user form from a selection on same form? Terry Tipsy Excel Discussion (Misc queries) 4 June 11th 07 02:59 PM
I am looking to see if anybody has an equivalant user form to Outlooks CONTACT form BruceJ[_2_] Excel Programming 2 October 15th 03 05:28 PM
Can I set a page of a Multipage form to active? John T Ingato Excel Programming 2 October 11th 03 12:15 AM
Using a string to point to a form object? plumbye Excel Programming 1 September 8th 03 06:49 PM


All times are GMT +1. The time now is 09:45 AM.

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

About Us

"It's about Microsoft Excel"