Auto-checking a checkbox based on cell contents.

  • Thread starter Thread starter Ramon Cantu Jr.
  • Start date Start date
R

Ramon Cantu Jr.

Is it possible to set or "check" a checkbox in real time, based on the
contents of a cell?

I know the cell link field can tie a cell to a check box, but (if I
understand it right) it's a one way link (meaning the cell reacts to
the check box).

Any help would be appreciated.

Thanks,

Ramon
 
Hi Ramon
this would require VBA using an event procedure like worksheet_change
 
If you link a cell to the checkbox (either from the Forms toolbar or the control
toolbox toolbar), then you can change that cell (true/false or 1/0) and the
checkbox will update.

But you can't have a formula in that linked cell if you're going to click on the
checkbox. It'll be overwritten.
 
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

protect check box and cells 2
Create Checkbox and link to relative Cell 3
Code to display a true or false value in the cell containing a check box 1
Can Checkboxes trigger the Worksheet_Change code? 3
CheckBox / Linked Cell Problem 16
Referencing Checkbox Name 1
Change event does not fire 3
Linking Checkbox to Worksheet 1

Back
Top