Recreate variable name in loop

[dodgyone]

I have a series of variables in a number sequence.

Const strTest1 = "A"
Const strTest2 = "B"
Const strTest3 = "C"

I am using a loop with a counter incrementing it. A simplistic example is shown below.

intCounter = 1
Do...
  Msgbox strTest & intCounter
  intCounter = intCounter + 1
Loop

I need to reproduce the variable name within the loop using the number of the incrementing counter. The result from the message box will be.

A
B
C

Any suggestions 'cause this is driving me bl**dy mad?!!!! Cheers...

 

[Craig0201]

Use an array instead of a load of redundant Const declarations?

C

 

[dodgyone]

I eventually decided to use an array, coded the solution then looked in here for any replies. That was the very suggestion. Thanks for taking the trouble to reply.

 

[tsuji]

>Msgbox strTest & intCounter
[tt]Msgbox eval("strTest" & intCounter)[/tt]