Increment Variable Control Name

dodger7 · Aug 22nd 2008

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

**Kenneth Hobson** · Aug 22nd 2008

Re: Increment Variable Name

You can put the results into an array or a string and then parse it on a character in your string using Split to make the array.

Increment Variable Control Name

Participate now!

Share

Users Viewing This Thread