how to dock a control to a cell in Excel ?

[Guest]

Hi,

I want to associate a checkbox control to an Excel cell so that when I
change the cell dimensions the checkbox remain centered on that cell.

Cen somebody help me ?

 

[Jon Peltier]

Hold down the Alt key while creating, moving, or resizing the control and
the edges of the control will stick to the cell boundaries. Right click on
the control, choose Format, and on the Properties tab, choose Move and Size
with Cells.

- Jon

 

[Guest]

Ok with the Alt key, but when I right-click on control property, the "Move
and Size
with Cells" box is still uncheckable.

 

[Jon Peltier]

The Forms toolbar controls do not all enable the Move and Size With Cells
property. The Controls Toolbox ones do. You can switch to the Controls
Toolbox type of control, or live with the limitations of the simpler
control.

- Jon

 

[Guest]

Ok, know that works.

Thanks.

The Forms toolbar controls do not all enable the Move and Size With Cells
property. The Controls Toolbox ones do. You can switch to the Controls
Toolbox type of control, or live with the limitations of the simpler
control.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______