I would like to insert the check box in particular cell through macro.
For example: On click of a command button i should be able to add the check box to A1
cell.
Sheets("Pipeline Products").Range("O" & i & ":AG" & i).Select
ActiveSheet.CheckBoxes.Add(4, 14.5, 72, 17.25).Select
With Selection
.Caption = ""
.Value = xlOff '
.LinkedCell = "C" & ToRow
.Display3DShading = False
End With
See Question&Answers more detail:os