thanks guys! that's what i hadn't figured out how to do yet.

appreciate it!!

J

"Mexage" wrote:

Dear Gixxer:

You can set the control to modify a cell with the LinkedCell property.

That way, you don't need to reference the control, instead you reference the
cell that your control "controls".

You can find the properties button on the control toolbox. A window appears
when you select your control (you need to be in design mode) and the
properties will appear in it.

Hope that helps!

G.Morales.

"Gixxer_J_97" wrote:

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