PDA

View Full Version : [SOLVED:] Trying to check if a checkbox is checked



next
01-15-2014, 02:37 PM
I have checkboxes with dynamic names, the pattern is as follows: "laborCheckbox1", "laborCheckbox2", etc.
I'm trying to see if they are checked. This is my if statement:

If (ActiveSheet.CheckBox("laborCheckbox" & cell.Row).value = 1) Then but I'm getting an error, object doesn't support this property.

Bob Phillips
01-15-2014, 02:40 PM
What is in cell?

Bob Phillips
01-15-2014, 02:41 PM
It should also be Activesheet.Checkboxes (plural)

next
01-15-2014, 03:21 PM
Thanks!
ActiveSheet.CheckBoxes("laborCheckbox" & cell.Row).value fixed it :)