The way it is designed to work is:
Link the checkbox to a cell, then reference the cell in your formula.

--
Regards,
Tom Ogilvy

"Gixxer_J_97" wrote in message
...
hi all,

is it possible to reference an object in a formula?
ie if a checkbox object exists on the worksheet, can something like this
be
done:

=IF(CheckBox1=TRUE,"1","0")

tia

J