Incremental Variable Names

[FIFARay007]

Quick question....

I'm using a For...Next loop and was hoping I could use it to change the variable name as well. What I have is below...

    For i = 1 To 11
        
        opt & i = EssVGetGlobalOption(i)
      
        
    Next i

What I'd like is to populate "opt1", "opt2", "opt3", etc. with the results of that function. Is this possible?

 

[iggydarsa]

creating a variable of ARRAY would be a more logical solution

 

[iggydarsa]

if you are not familiar with arrays, this might give you an idea

Sub test()
Dim x(3) As Integer 'Create an array that can hold 3 integer values

'Populate the array with 10, 20, and 30
For i = 1 To 3
    x(i) = i * 10
Next i

'Display the values one by one
For i = 1 To 3
    MsgBox x(i)
Next i
End Sub

also, you can do a little research within this forum for more valuable information

 

[FIFARay007]

Solid. Thanks for the info.