List of Check Boxes with MACROS

[abamasd]

Hi Friends,

I am working on an excel work book, which is consist of 10 data sheets and 10 graph sheets...! I have picked the two columns from each data sheet Column "WORK DONE" and Column "MONTHS" for each chart in chart sheet.

I have another sheet called "HOME" on this sheet i have 10 Check box list and OK button.

My Requirement:

1. When I Check the Check box1 and click on OK button, Macro should take to Chart 1
sheet.

2. When I Check the Check box1 and 2 it should show the comparative chart of Data
sheet1 and Data sheet2.

3. When I Check the Check box3,5,9 & 10 it should show the comparative chart of Data
sheet3,5,9 & 10. and so on in between all 10 check boxes..!

Can somebody please help me:

Your Help wil be more appriciable
Abamasd.

[teylyn]

Hi abamasd,

welcome to the forum.

Check boxes, by nature, allow more than one selection. A check box is not a good starting point to select an individual sheet to navigate to. Where should Excel take the user if they tick more than one box?

Instead of check boxes, you can easily create hyperlinks to the data sheets. Then the user just needs to click the hyperlink.

Chart sheets are not that easy to hyperlink to, but there is a workaround with VBA code. (ref. http://peltiertech.com/Excel/Hyperlinks.html)

The code goes into the worksheet module and you need to adjust the code to include any more cells listing chart sheets.

See attached.

[abamasd]

Hi Teylyn,

First of All thanks for your reply:

I have already done what u have sent in ur attachment, thts a simple part for me. the tricky part i wanted to know.

Please refer my attached sheet with full of Macros & Hyperlinks. and kindly refer my comments and requiremnt on sheet Comparative Charts.

Please hlep me!

Thanks In Advance.
Abamasd