ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I get a Check Box to set a value in a cell when is checked. (https://www.excelbanter.com/excel-programming/326227-how-do-i-get-check-box-set-value-cell-when-checked.html)

aaarbelo

How do I get a Check Box to set a value in a cell when is checked.
 
Heloo there
I'm trying to get a check box to set a value in a cell whect is checked and
to remove it when is uncheck, Does any body can help me with that.
Thank you

Bob Phillips[_6_]

How do I get a Check Box to set a value in a cell when is checked.
 
Link it to the cell, and the cell will be True or False.

If forms checkbox, right-click on the checkbox, select the Format Control
option , the pick the control tab, and put the link cell address in the link
field.

If a controls toolbox checkbox, go to design mode, right-click on the
control, and choose Properties from the menu. Put the cell address in the
Linkedcell property.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"aaarbelo" wrote in message
...
Heloo there
I'm trying to get a check box to set a value in a cell whect is checked

and
to remove it when is uncheck, Does any body can help me with that.
Thank you





All times are GMT +1. The time now is 12:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com