#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Multipage

I have a Userform with 4 Multipages, first Multpagpage belong to sheet1,
second Multipage to Sheet2, and so on. Is there a possibility to get e.g.
Multipage3 on Top when I open the Userform from Sheet3?
Thanks.
Aksel Børve


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,624
Default Multipage

If I understand you correctly:


Private Sub UserForm_Initialize()
MultiPage1.Value = ActiveSheet.Index - 1
End Sub


In article ,
"Aksel Børve" wrote:

I have a Userform with 4 Multipages, first Multpagpage belong to sheet1,
second Multipage to Sheet2, and so on. Is there a possibility to get e.g.
Multipage3 on Top when I open the Userform from Sheet3?
Thanks.
Aksel Børve


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 tab? capt Excel Discussion (Misc queries) 2 January 28th 08 08:01 PM
MultiPage OM Excel Discussion (Misc queries) 2 April 7th 06 01:31 PM
How do I use multipage Lawrence M Watt Excel Discussion (Misc queries) 1 October 24th 05 02:55 PM
MultiPage Michael[_25_] Excel Programming 3 January 6th 04 12:49 PM
Multipage Paul Excel Programming 1 July 9th 03 02:34 PM


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

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"