You have to be in design mode.
Right click on the checkbox
Select Properties
Type the address in the LinkedCell property box.
Get out of design mode to test.

I like to give those cells a custom number format:
;;;
(3 semicolons)

That'll hide the value, but I can still see it in the formula bar with that cell
selected.

Carla wrote:

Thank you your assistance has now led me to my next question. Previously, I
was able to link the forms checkbox to the cell in which it resided and was
able to create an if statement based on whether it was checked (true) or not
(false). How do I do that sort of thing with a control checkbox?

Thank you,
Carla

"Gord Dibben" wrote:

On the Control Toolbox Toolbar at upper left you will see an Icon looks like a
T-square and a triangle.

Click on that to get out of "design mode".


Gord Dibben MS Excel MVP

On Sat, 31 May 2008 16:31:00 -0700, Carla
wrote:

I need some more assistance. I did a test check box from the control
toolbox. I can't get it to do the check mark, it stays in some sort of
"edit" mode (or something). Any thoughts?

Thank you,
Carla
St. Petersburg, FL

"Dave Peterson" wrote:

There are two checkboxes that look very much alike.

The checkbox from the Forms toolbar does not allow this setting.

The checkbox from the control toolbox toolbar does allow it.

Are you sure you used the checkbox that you really wanted to use???

Carla wrote:

Dave, this is an old one, but it is assisting me with fixing my current
problem. The "move and size with cells" is gray, not an option to choose.
I'm sure that is why I am having a similar problem as the person below. Any
insight as to why I am not being allowed the option to check that box? The
other two are available to pick.

Thanks,
Carla
St. Petersburg, FL

"Dave Peterson" wrote:

If you're using checkboxes from the Control Toolbox Toolbar, you can select them
all and then rightclick on the selection and:

Format Control|Properties tab|Check Move and size with cells

And make sure that each checkbox is completely in that cell/row.

If you're using checkboxes from the Forms toolbar, you won't be able to do
this. (I'd replace them with the control toolbox toolbar version.)

Goldenfoot wrote:

I have 8 check boxes in Excel on rows 1:4 and 6:9. I have other macros that
hide and unhide these rows together or separately. When all rows are hidden
and then unhidden, the checkboxes all stack up at the bottom on row 10.

Any property value I am overlooking with respect to the movements?

Thanks,
GoldenFoot

--

Dave Peterson


--

Dave Peterson




--

Dave Peterson