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

[K Dales]

In the code module for the userform:

Private Sub ComboBox1_Change()

Worksheets(ComboBox1.Value).Select

End Sub

"Greg B" wrote:

> 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
>
>
>