Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mutipage
strImput = ActiveSheet.Cells(3, 2).Value
If LCase(strImput) = "page2" Then MultiPage1.Value = 1 Else MultiPage1.Value = 0 End If The index of the first page is 0 or maybe something like - MultiPage1.Value = MultiPage1("Page2").Index Regards, Peter T "Richard" wrote in message ... 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 control question | Excel Programming | |||
Extracting a Single Worksheet froma Mutipage Workbook | Excel Discussion (Misc queries) |