| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Control + Home to get to A1 cell | Excel Discussion (Misc queries) | |||
| Excel control cell display of data with passwords | Excel Worksheet Functions | |||
| Excel: Format Control: 'cell link' reamins constant. How to copy | Excel Worksheet Functions | |||
| How can I control cell movement with the Tab key? | Excel Discussion (Misc queries) | |||
| Control Tab from Combo box- format control missing!! | Excel Discussion (Misc queries) | |||
Linear Mode
