Checklist using Macro

[shantraj.antin@gmail.com]

Dear Ninjas,

All these days I used to update the checkpoints using drop down. I need your support for building my checklist using macro.

In the file uploaded,

> For every "cased ID "check points should be followed. check points can be "Applicable checks" or "Not Applicable" as in row 6. When I click on the cell under "Applicable checks" or "Not Applicable" then color of the cell should change and "Checked" or "NA" should populate under respective column.

Note: The check points are dynamic, I frequently keep updating the check points. If any new check points are added or removed color code macro should work or should not work for that cell.

> Is it possible to clear the checks under respective columns if by mistake I made any cell active. Hence I have put "Clear Checks" for every case so that once I make this cell active the respective column cells are non colored and blank as default.

> Under Row total check points I have put the formula =COUNTIF(B7:B106,"Checked").

> In each sheet I have different activities, the check points may differ but logic is same for all the sheets.

Kindly help me on this automation.

 

[Luke M]

Check out this code. Rather than a single click, which can be done accidentally, I set it up to take a double click to "activate" the code. Code is under the ThisWorkbook module.

 

[shantraj.antin@gmail.com]

Thanks Luke for your support.

Code is working fine. The double click option you have put is more comfortable to use.

Thanks a lot