Make a checkbox add a specific text in another cell

[vikramjeet23]

I have added a checkbox in a cell. I want the character " ' " to be added to to another cell if I check the box. The other cell stays blank if the box is not checked...Thank you

 

[bobsan42]

For this to work the checkbox must be a Form Controls Object (and not ActiveX) and must be linked to a cell.
Lets assume the checkbox is in cell A1.
Right click the check box, select Format Control ... from the menu. Go to Control tab and in the Cell link field type (or select cell) A1. Press OK.
Now put this formula in another cell e.g. A2:

=IF(A1," ' ","")

The other way to do it is to use a macro.