G'day people
I have the following loop set up:
Code
Private Sub CommandButton2_Click()
Dim counter1 As Long
Dim myFrame As MSForms.Control
For counter1 = 1 To 30
Set myFrame = Me.Controls("Frame" & counter1)
Dim objControl As Control
For Each objControl In myFrame.Controls
If objControl.Value Then
myframe1result = objControl.Caption
Exit For
End If
Next
Next counter1
End Sub
Display More
However during each loop "myframeresult" is overwritten. I need to increment this to "myframe2result", "myframe3result" etc for each loop so that each is stored in a separate variable.
Thanks