LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default Determining Which Page of MultiPage Initially Shows

I have UserForm1 with MultiPage1. Page0 has three option buttons, One,
Two, and Three. If One is selected, the next page shown is Page1 and
so on. Once the process is complete, the code dumps various
information into a worksheet (including the value of the option button
selected).

If the user runs the code again, instead of initially showing Page0,
I'd like to initially show the page corresponding to the option button
selected the first time around. Since I have the selection already in
the worksheet, I figure I can use that to run a Select...Case, but I
cannot seem to get the proper page of MultiPage1 to display as desired.
Page0 always seems to pop up. I'm assuming that I would put this in a
UserForm_Initialize procedure.

Thanks,
Mike.

 
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
How to delete entire page 2 so document shows as 1 page only Elinita New Users to Excel 1 November 22nd 09 06:35 PM
activate a page of a Multipage in Userform Jeff Excel Discussion (Misc queries) 1 February 8th 08 06:16 PM
How do I set the focus to a page in a multipage Azza Excel Programming 2 November 23rd 04 10:42 PM
excel fit to 1 page shows 1 page but not all data is on that page Jans Excel Programming 1 September 2nd 04 01:49 AM
how to put a reference from a page of a multipage form to another page Valeria[_2_] Excel Programming 2 January 25th 04 08:21 AM


All times are GMT +1. The time now is 02:11 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"