Turning an excel cell into a check box - but selected cell range only not the whole sheet

[MilsonHQ]

I really like the answer to the first part of my title found in this thread Turning an excel cell into a check box

The code they gave to do that task is as follows:

Please Login or Register  to view this content.

But can anyone tell me, how would I modify the above code to target only specific cells that are double clicked and not the entire sheet? For example just a range say A:1 through C:20 or multiple ranges on the sheet A:1 through C:20 and A:26 through C:46 or similar.

Also

How about the ability to remove the check mark if the cell is double clicked again?

[ChemistB]

In this example, there are two ranges A1:B20 and D1:D20
I have added the option to clearcontents if it already contains a checkmark.

Please Login or Register  to view this content.

Does that work for you?

[MilsonHQ]

Thank you very much for such a fast helpful reply, this works perfectly!