Dynamic Assign of Variable

Hi,

Following are my code

If ComboBox1.Value = "North" Then
Approach_Max = North_Max
ElseIf ComboBox1.Value = "West" Then
Approach_Max = West_Max
ElseIf ComboBox1.Value = "South" Then
Approach_Max = South_Max
ElseIf ComboBox1.Value = "East" Then
Approach_Max = East_Max
End If

For i = 1 To Approach_Max
'Execute code
Next i

North_Max, West_Max, South_Max, East_Max already have values.

What i want do is to avoid this if condition.

Is there any way like this

test = ComboBox1.Value & _Max // for eg: if north, it will be North_Max, so North_Max value will be stored in test.

For i = 1 To test
'Execute code
Next i

Thanks

Thanks... It works perfectly...