Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mutipage
Your code is not valid:
MultiPage1.Page(1).Visible = True you select the pages by value: UserForm1.MultiPage1.Value = 0 0 is the first sheet in the index -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "Richard" wrote: Hello, Is there anyone can help with the Mutipage control? I want to change the page based on user input by using VBA coding in the UserForm_Initializing. Example Dim strImput as String Private Sub UserForm_Initialize() strImput = Worksheets(strActiveSheet).Cells(3, 2).Value If strImput = "page2" Then MultiPage1.Page(1).Visible = True Else MultiPage1.Page(2).Visible = True End If End Sub I'm having is problem with "MultiPage1.Page(2).Visible = True". This code is not working. Please Help..................... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mutipage | Excel Programming | |||
MutiPage control question | Excel Programming | |||
Extracting a Single Worksheet froma Mutipage Workbook | Excel Discussion (Misc queries) |