help with checkbox in For Loop
Posted by Mike on August 21, 2001 7:43 AM
I am trying to put a series of checkboxes into a for loop. The loop will look for 'true' checkboxes and if a checkbox is 'true' an action will be performed (data pulled in and stored from other excel files). Currently the user puts an 'X' in a specific cell for the action to take place, but I would like to replace it with a checkbox.
Somehow the for loop needs to cycle through checkbox1 to checkbox18. ("For Checkbox1 to Checkbox18" doesn't work). Then the IF statement inside the For Loop needs to examine the checkbox ("IF Checkbox(?).Value = True Then")
any ideas?
Current For/If commands
For Row = 8 To 25
If Cells(Row, 4) = "X" Then
{Perform action}
Endif
Next Row