View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default Multipage dialogbox

1.
Form1.Multipage.Value = 3 'or whatever value, note first page has value 0

2.
Private Sub MultiPage1_Change()

Select Case MultiPage1.Value
Case 0
Case 1
Case 2
Case 3
Sheets("Wire Marking ").Activate
End Select

End Sub


RBS

"Patrick C. Simonds" wrote in message
...
Wondering two things:

1. What do I need to put in my UserForm_Initialize() subroutine to always
open the UserForm with the Welcome tab active?

2 What code would I need to go to a particular Worksheet when I click on
a Tab. So if I were to click on the "Wire Marking" tab of the
MultiPage Dialogbox the Wire Marking worksheet would be active?