Checkbox will activate if a specific cell has a value

[Adnamut]

Hi everyone! I am having a hard time in this part so I am looking forward to hear something from you. Any from of help will be appreciated so thank you in advance.

So my main problem here Is I want the checkboxes clickable if and only if the cells in the dropdown table has a value.
Ihope you can help me with this one. BTW I am using excel 2007

Fieldsetup.jpg

Best Regards
Yaj

[haripopuri]

Upload your workbook. You can use worksheet change event to do this.

[Adnamut]

Hi attached herewith is a copy of my workbook. I hope you could help me. Thanks

[haripopuri]

Is there any mapping between cells and check boxes? Like which check box should be activated if which cell is has a value. I did for G7 and first check box. You can expand it further based on your requirement.

[haripopuri]

Forgot to mention, I put code in first sheet code window. I deleted some of existing code there (didn't check what it is)

[Adnamut]

Hi! I tried your code and manipulated it so many times. But I ended up clicking only checkbox1. What do you think is the cause of this?

[Adnamut]

Hi after multiple tries I manage to manipulate your given code the way I want it. Thanks. How can I mark this thread solve? thanks

[haripopuri]

You may wish to add a point to my rep by clicking the star below each post.

To mark your thread solved do the following:
New Method
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved

Old Method
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save