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

Combo Box code
 

Worksheets(Combobox1.Value).Activate

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Gordon" wrote in message
...
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