Put a check-box in the middle of the cell

[alexgoaga]

Hey guys,

I have a question regarding the possibility of setting a simple check-box in the middle of the cell in order to be activated anywhere in the cell?
The size of the selection of the check-box can be easily modified from the format options, but i don't find any solution to center it.


I have attached a xls with a simple check-box in order to be easily to explain

Thank you,
Alex

[AliGW]

Use the selection nodes to make the bounding box of the check box smaller, then drag it to the centre of the cell under the A.

[alexgoaga]

i want the "bounding box" to be equal with the cell size and the little checkbox to be centered then so i can "click" anywhere to activate the checkbox.

[AliGW]

Why does the cell have to be that wide? Can't you make it smaller? There is no other way of making the check box central, as far as I know.

[alexgoaga]

It's a request to be that wide or more. Neither a vba code in order to make it work?

[AliGW]

I don't know about VBA. Possibly ... One of our coders should know.

[popipipo]

Use the ALT button to adjust the size the of the box

[alexgoaga]

11111.png @popipipo

[AliGW]

Use the ALT button to adjust the size the of the box

The OP has already stated that he does not want to change the size of the box!

[popipipo]

It must be my English, but this is what he said

i want the "bounding box" to be equal with the cell size and the little checkbox to be centered then so i can "click" anywhere to activate the checkbox.

he does not want to change the size of the box!

[AliGW]

No, it's not your English, which is infinitely better than my Dutch, but if you look at his file you will see how he has it set up. Maybe read the exchange between him and me in the first few posts, and that will make it clear: he doesn't want to change the width of the cell and he wants the check box's bounding box to fill the whole cell. When set up like that, you can't centre the check box.