Jeyanthan has attended:
Excel Intermediate course
Excel VBA Intro Intermediate course
Group Box & Check Box
Hi
I have recently attended the Excel Advance 3 course and much appreciate your help on following.
I created a Work sheet with following sheet names
1) Sheet 1 β General Dash Baord
2) Sheet2-Company 1 DashBoard
3) Sheet3-Company2DashBoard
In Sheet 1,
I have created Group Box with the β Company Namesβ.
I have created 02 check box within the Group Box ( Such as Company 1 & Company 2)
Could you please guide me to create a formula to perform the following?
By pressing a check box 1(company 1), then it should take to Sheet 2(Company 1)
By pressing a check box 2(company 2), then it should take to Sheet 3(Company 2)
Thanks & regards
Jey
RE: Group Box & Check Box
Hi again Jey
A way to have the option buttons navigate to appropriate sheets would be to create macros and assign to each button.
For the first one it would be
Sub GotoDB1()
Sheets("Company 1 Dash Board").Select
End Sub
The alternative way without macros is to create hyper links to the dashboard sheets.
Please let me know if you need more information about either method.
Doug
Best STL
