Forum Discussion
Checkboxes
It's always difficult with checkboxes... As far as I know, this only works with VBA.
The how, however, depends on whether all the checkboxes are already in place and you just want to adjust the cell linking, or whether the checkboxes have yet to be created.
Sub CheckBox()
Dim chkElement As CheckBox
For Each chkElement In ActiveSheet.CheckBoxes
chkElement.LinkedCell = chkElement.TopLeftCell.Address
Next chkElement
end sub
Note: if the check box is not exactly on (or a little below) the upper edge and exactly on (or a little to the right of) the left edge of the desired cell, it may happen that another cell is entered as the cell link. Excel can't know exactly which cell you want to link and you have to define a criterion - in this specific case the upper left corner.
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
I want to put a checkbox in a cell (let's say B2) and then grab the lower right hand corner of B2 to drag it down by let's say 200 cells, therefore putting that checkbox in cell B3, B4. B5 etc etc).
Hope this is clearer?
Maybe this guide will help you where you can just drag down the cell with the check box with the mouse... it's probably the way you see in many videos.
How to insert multiple checkboxes
In Excel, Fill Handle is a function to do many things. It can also fill the checkboxes. First, you need to insert a check box.
Proceed as follows:
1. Click Developer on the menu bar, click Insert, and check the box under Form Control.
Note to 1:
The Developer tab isn't displayed by default, but you can add it to the ribbon.
On the File tab, go to Options -> Customize Ribbon.
Under Customize the Ribbon and under Main Tabs, select the Developer check box.
2. Click on the check box and you will see a plus sign pointer.
Click where you want to add the check box.
3. Select the check box (Form Control), move it to a cell and clear the check box name.
4. Then select the cell where the check box is located. Then use your mouse to drag the cell down over the range of cells you want to fill.
Thus you have check boxes in the desired cells.
*Attached is a file where you can simply drag down the cells of the check box with the mouse.
Hope that helped...if not, please just ignore.
I know I don't know anything (Socrates)
That simply won't work. Filling or dragging only replicates the cell, not objects floating above it such as a check box.
Apart from that, managing hundreds of check boxes would be a nightmare. I'd keep it simple and let users enter an "x" in the cells themselves, or something similar.
HansVogelaar Hi Hans,
Oh, I find this odd? I’ve seen various videos online of people doing exactly that, putting a checkbox inside a cell, then dragging that cell down for it to replicate. I tried it on excel at work and it worked, now at home I can’t get it to!
I second HansVogelaar 's recommendation.
I've come across many workbooks using hundreds of objects (it really doesn't matter if they're check boxes, small pictures, etc.) and the common thread is the navigation in these workbooks is very slow. The issue is Excel will struggle to render the objects on screen (Even if the objects are very small).
