is there a way to assign a checkbox to a cell

Question

is there a way to assign a checkbox to a cell

Anonymous

Fellow Excellers!!

I have a list of items that somebody should tick off. It is actually a list of equipment for a new employee, so his superior ticks off whether the new employee gets a laptop, mobile, lease car, petrol card, software a, software b and so on.

The normal tickbox is not locked into the cell but like hovers above the cell so it may easily shift, making the administration of the sheet difficult. I have to manually align the tickbox above the cell. If my tickbox was assigned to the cell, the alignment would no longer be necessary, the tickbox should just stay within the cell.

Please tell me how I can solve this?

BW Peter Hansen

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

0 additional answers

Answer 1

There are two types of Checkbox control available: Form Control and ActiveX. The Form Control checkbox does not have the ability to be Moved and Sized with cells. The ActiveX checkbox control does.

In the Developer tab, Controls group, click Insert and then choose the Checkbox control under ActiveX Controls.

Click in your worksheet at the desired location.

Right-click on the control > Format Control > Properties tab > Move and size with cells > OK.

To be able to use the checkbox, you need to switch off Design Mode (next to Insert on the devleoper tab).

Tip: to be able to snap the size of the control to be the same as the cell, insert a shape (Insert tab > Shapes > Rectange...) and then in the Drawing Tools > Format tab, in the Arrange group click Align > Snap to Grid. You can then resize the checkbox control so it exactly fits in a cell.

Hope that helps.

Cheers

Rich

Share via

is there a way to assign a checkbox to a cell

0 additional answers