TickBox

[Idris]

Dear Friends

I need to insert a tick box on each row starting from A7:A6201 - can it be done in excel? - please advice.

Thanks
Idris

 

[___]

Dear Friends

I need to insert a tick box on each row starting from A7:A6201 - can it be done in excel? - please advice.

Thanks
Idris

Select the cells you want a checkbox in and run this....

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