Hi,
I am using the following macro to add multiple checkboxes to my spreadsheet:
Sub MakeCheckbox()
Dim myRng As Range
Set myRng = Selection
For Each ctrl In myRng.Cells
ActiveSheet.CheckBoxes.Add(ctrl.Left, ctrl.Top, ctrl.Width, ctrl.Height).Select
Next
myRng.Select
End Sub
My problem is that the checkboxes have text next to them (checkbox 1 etc.) when I only want the box itself. Can anyone tell me how to do this? I'd also be interested in finding out if it is possible to 'anchor' the checkboxes to their respective cells.
Thanks, Chris
Bookmarks