If statement using FORMCHECKBOX?

Question

Is it possible to have an IF statement using FORMCHECKBOX. 

So if ABC = yes, checkbox will be checked, if not, it's left blank. 

I know how to use this using a Wingding which contain an image of a checked box and an empty box but they look pretty ugly!

Answer 1

Form checkboxes can appear on sheets or userforms, but either can be linked to a cell (if the cell value is TRUE the checkbox is checked, and visa versa; if the cell value is FALSE the checkbox is unchecked and visa versa).

Rightclick the checkbox, format control, control tab, add a cell link. The linked cell will be overwritten with either TRUE or FALSE depending on the checkbox state.

Then replace that TRUE or FALSE in the linked cell with a formula to check if the user entry cell matches your target value. In this example, I linked the checkbox to D2. If desired, hide that helper column so your users don't see the TRUE/FALSE values

Answer 2

I am using an X box and empty box.  They are not so ugly on their own, but the form has regular form checkboxes that look a little different, so the overall impression of the form is a bit ugly (ok, a teeny bit ugly).

Answer 3

I would not consider the Wingdings 254 and 168 to look "pretty ugly"!

What symbols did you use?

Answer 4

Thanks so much, but this is for Word, not Excel.  Might you have a solution?