Hello Friends
I am looking for a simple macro.
The value of cells in column M and J is linked to two checkboxs in each row. When I check the first box, the value of cell in column M becomes "TRUE", but when it is unchecked it becomes "False". Same is with the second checkbox. The second check box is linked with cells in column J.
I want the user to check only one box in each row. I know this can be done by using the Option Button & group box, but there are some other macros in the same worksheet, which prohibits me from using the group box. Hence I am using the check box option obtained from Form Toolbar.
I was looking for a macro which will get fired with any of the check box & will give me an error message if the user checks both the boxes