Jeyanthan has attended:
Excel Intermediate course
Excel VBA Intro Intermediate course
Option Button & Check Box
Hi,
I recently attend the Advance Excel Training Part 03 . Currently i am tru to create a excel dashboard with followoing.
I creasted a Group Box with the name of Group consolidated accounts.
Then I created 04 Check boxex with the name of company 1, company2, company 3, company 4.
The above Group fucntions was in the sheet 1.
I have a another sheets name as Dash Bord2, Dashboard3,Dashbard4.
I need a help to perform the following.
When i click check Box1 (company 1), then i should have access to sheet'Dash Baord2' and same likewise when i am clicking other compnaies it should go to Dashbaord3 7 Dash Board 4.
Thanks in advance for your help.
Regards
Jey
RE: Option Button & Check Box
Hi Jey
Good of you to start applying option buttons so quicly after your training. To have the option buttons jump you to right dashboard you can assign a macro for each one. For example in Module1 write
Sub GotoDash1()
Sheets("Dashboard1").Select
End Sub
After copying and creating macros GotoDash2 and GotoDash3 assign each macro to the correct option button. Then save the workbook as a macro enabled file with extension xlsm.
Another way to consider is setting up hyper links on circles (using Insert, Shape) to jump you to the right dashboard. Assign the hyperlink to each circle choosing 'Place in this Document' and click on the required dashboard sheet.
Hope that helps.
Regards
Doug Dunn
Best STL
