Combo Box code

Hi...

I've populated a combo box with say sheet 1, sheet 2, sheet 3, and sheet 4.
What code will take the user to sheet 2, if sheet 2 is selected from the drop
donw combo box. Are there amny examples of this around...

Pleasing here...thanks

G

Worksheets(Combobox1.Value).Activate

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Gordon" <Gordon@discussions.microsoft.com> wrote in message
news:050CE24C-8844-4786-B986-8E27D54307E1@microsoft.com...
> Hi...
>
> I've populated a combo box with say sheet 1, sheet 2, sheet 3, and sheet
4.
> What code will take the user to sheet 2, if sheet 2 is selected from the
drop
> donw combo box. Are there amny examples of this around...
>
> Pleasing here...thanks
>
> G