tharindudk.xlsm

Hi tharindudk,

Take a look at the attached, I didnt do any checkboxes and instead simply allowed cell A1 to be the value of the checkbox.

I am not sure I have your requirements 100% implemented but it should be a start for you

and I am 100% sure there are many more clever ways to resolve the problem

jmac