Combo Box

[Greg B]

Hi all,

I have a combobox which shows worksheets that have a certain element in it ,
How do I get it to activate the page selected in the combo box.

the userform is called "formspage"

combobox.1

Thanks in advance

Greg

 

[Guest]

In the code module for the userform:

Private Sub ComboBox1_Change()

Worksheets(ComboBox1.Value).Select

End Sub