Open Specific Worksheet Using Button Form Control in Excel

Joined
Jul 21, 2016
Messages
2
Reaction score
0
Hi All,

Kindly need your help.

I want to use button function of form control to open specific worksheet.

For Example.
In worksheet(1), I make drop down list as follow Football, Basket, Tennis.
I also already make worksheet(football), worksheet(basket), and worksheet(tennis) and hiding all these worksheets
In worksheet(1) I choose list football and I click button form control and only the worksheet(football) will open.

Any advise.
Thank you
 
Back
Top