Using a combobox to select sheets

[T De Villiers]

Hi,

I have a combobox (stored with worksheet names), whenever I select a
value the sheet will be selected.

Many Thanks
Tariq

 

[Tom Ogilvy]

Are you asking a question? Perhaps:

If combobox1.ListIndex <> -1 then
Worksheets(Combobox1.Value).Select
End if

You might need to qualify Combobox1 depending on where it is.

--
Regards,
Tom Ogilvy


"T De Villiers" <[email protected]>
wrote in message
news:[email protected]...