I am trying to loop through a group of textboxes that are on an excel sheet
(not in a userform) to see if they have been checked or not. How can I do
this. Below is what I have now.

Dim Ctrl As CheckBox

For Each Ctrl In Sheets("Program").CheckBoxes
If Sheets("Program").CheckBoxFx = True Then
FDirect = "FsX"
Else
If Sheets("Program").CheckBoxFy = True Then
FDirect = "FsY"
Else
If Sheets("Program").CheckBoxFz = True Then
FDirect = "FsZ"
End If
End If
End If
Next Ctrl