control toolbox objects and formulas
 

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

control toolbox objects and formulas
 

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

control toolbox objects and formulas
 

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

control toolbox objects and formulas
 

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