how to dock a control to a cell in Excel ?
 

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 ?

how to dock a control to a cell in Excel ?
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Laurent CASTEIL" <Laurent wrote in
message ...
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 ?

how to dock a control to a cell in Excel ?
 

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" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Laurent CASTEIL" <Laurent wrote in
message ...
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 ?

how to dock a control to a cell in Excel ?
 

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
_______


"Laurent CASTEIL" wrote in
message ...
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" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Laurent CASTEIL" <Laurent wrote in
message ...
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 ?

how to dock a control to a cell in Excel ?
 

Ok, know that works.

Thanks.

"Jon Peltier" wrote:

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
_______


"Laurent CASTEIL" wrote in
message ...
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" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Laurent CASTEIL" <Laurent wrote in
message ...
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 ?