Using a combobox to select sheets
 

Hi,

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

Many Thanks
Tariq


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=503825

Using a combobox to select sheets
 

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"
wrote in message
news:T.De.Villiers.221xha_1137959401.6463@excelfor um-nospam.com...

Hi,

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

Many Thanks
Tariq


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile:
http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=503825