How do I get a Check Box to set a value in a cell when is checked.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Make a maro run upon leaving a cell 0
Linking Check Box in User Form to Workbook 8
Check boxes 4
Some trouble assigning a string to a variable 22
Cell Referencing too and from check boxes? 0
Use a Variable to Reference a Check Box Object 7
Clear check boxes? 1

Back
Top