Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a UserForm with a MultiPage control. The MultiPage has 4 pages
(.Value = 0 through 3). Everything works fine until I add another page. I have a CommandButton on the UserForm that directs the user to the Next page. When MultiPage.Value = 0, the following code is run: Select Case MultiPage1.Value Case 0 ' If Page1 is active... With MultiPage1 .Value = MultiPage1.Value + 1 ' Move forward 1 page .Pages(1).Enabled = True ' Enable Page2. .Pages(0).Enabled = False ' Disable Page1. End With CommandButton1.Enabled = True ' Enable Back button. cbRanges.SetFocus ' Give cbRanges focus. Case1 Case2 Case3 End Select When I add a 5th page (MultiPage.Value = 4), and run the code, pressing the "Next" CommandButton causes MultiPage.Value = 4 rather than 1 (MultiPage1.Value is 0 on Page1, so adding 1 should result in MultiPage.Value = 1, no?). I am really confused as to why when I add the 5th page, 0 + 1 suddenly equals 4. I could change the index of the pages, but then the order of the MultiPage would not logically follow the sequence of events (I know it doesn't matter from a programming perspective, but when setting this up, I'd like the MultiPage to be in the right order). TIA Mike -- Michael J. Malinsky |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
activate a page of a Multipage in Userform | Excel Discussion (Misc queries) | |||
MultiPage tab? | Excel Discussion (Misc queries) | |||
MultiPage | Excel Discussion (Misc queries) | |||
How do I use multipage | Excel Discussion (Misc queries) | |||
Multipage | Excel Programming |