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

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

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

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