Controll elements in cell???

[weeze2]

Hi there.
Is it possible to bind conrtoll elements like a checkbox to a cells in MSExcel?

 

[attrofy]

Bump

I too am interested. I have seen an option when right clicking a control box (Format Control-> Properties-> Move and Size with cells) - but this seems to have no effect.

 

[attrofy]

I have found a way to bind Controls to cells. It appears to work with everything I have tried. But I haven't tried all controls.

Right click on the Control. THen select Format Control. Under the Protection tab, be sure that "Locked" is unchecked, then go to properties, and check "Move & Size with cells".

 

[GlennUK]

Do you both mean having the checkbox linked to a cells contents, so that it will show TRUE or FALSE depending on whether the checkbox is checked or not?

If so, for checkboxes created with the Forms Toolbar, right-click the checkbox, and from the shortcut menu choose Format Control, and click the Control tab, where there is a box labelled Cell Link which can be used to specify the linked cell.


For checkboxes created using the Control Toolbox toolbar, click the Design Mode button on the toolbar, and select the checkbox so that it is selected, and then click the Properties button on the toolbar, which displays all the properties of the checkbox. One of the properties is called LinkedCell, and you type the cell reference next to it.

Phew, I hope that's what you wanted.

Cheers, Glenn.