Is there a way to loop through controls (e.g. vb checkBox) that are on the worksheet. I know you can do this for the userForm as follows
For Each ctrl In UserForm1.Controls
If TypeName(ctrl) = "CheckBox" Then
MsgBox CheckBox.Text
End If
Next ctrl
Is this possible for an active worksheet?
Bookmarks