next
01-14-2014, 10:46 AM
How do I assign an ID to a checkbox?
With ActiveSheet
.CheckBoxes.Add(740, 270, 75, 15).Select
.CheckBoxes.Add(Cells(r, "L").Left + 20, Cells(r, "L").Top, 85, 15).Text = "Continuous"
End With
Right now VBA is using default CheckBox1, 2, 3, etc., but I need to be more specific.
With ActiveSheet
.CheckBoxes.Add(740, 270, 75, 15).Select
.CheckBoxes.Add(Cells(r, "L").Left + 20, Cells(r, "L").Top, 85, 15).Text = "Continuous"
End With
Right now VBA is using default CheckBox1, 2, 3, etc., but I need to be more specific.