No can do. The best you can do is to link the checkbox to a cell and check
that

=IF(G1,"Yes","No")

--

HTH

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


"big t" wrote in message
...
Hi everyone,

I need to check a checkbox in a formula - something like this:

=if(mycheckbox, "Yes", "No")

I'm using the ActiveX style checkbox - ie the one from the Control
Toolbox.

Any ideas?

TIA
big t