vikramjeet23
New Member
- Joined
- Mar 14, 2015
- Messages
- 7
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
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Make a checkbox add a specific text in another cell
bobsan42
Well-known Member
- Joined
- Jul 14, 2010
- Messages
- 2,027
- Office Version
- 365
- 2019
- 2016
- 2013
- Platform
- Windows
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.
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.
Last edited:
Upvote
0
