help with mulitpages and ComboBoxes

[jose001]

Morning guys,

I have an issue with a multipage which I really hope someone might be able to help me with. I have a very simple form which consists of a comboBox and a 40 page multiform. I’d like to link pages in the form to options in the comboBox so that it changes when the comboBox changes, is this possible. I’ve googled for hours and can’t find a sausage so I’m guessing it’s either a very basic question which I shouldn’t be asking or not possible? I thought it might be as simple as an ‘IF’ statement but I can’t get that working, I can’t move forward with my project until I manage to do this so any help would be greatly appreciated.

Many Thanks

 

[rcbunting]

Something like this...

Private Sub ComboBox1_Change()
    Select Case ComboBox1.Text
        Case "Option 1"
            UserForm1.MultiPage1.Pages(0).Enabled = True
        Case "Option 2"
            UserForm1.MultiPage1.Pages(2).Enabled = True
        Case "Option 3"
            UserForm1.MultiPage1.Pages(3).Enabled = True
        Case "Option 4"
            UserForm1.MultiPage1.Pages(5).Enabled = True
        Case "Option 5"
            UserForm1.MultiPage1.Pages(17).Enabled = True
        Case "Option 6"
            UserForm1.MultiPage1.Pages(20).Enabled = True
            UserForm1.MultiPage1.Pages(20).Textbox1.Text = "You got to this page by changing the ComboBox selection!"
        Case Else
            'Don't do anything for unhandled selections
    End Select
End Sub