I know I can direct use Public Variable in code, but sometime I wish to use variable to reference it. Such as:

**Define Public Variable in Module

Public strA1 as string
Public strA2 as string
....
Public strA10 as string

***In Form VBA code, I wish can use For..Next loop command to reference Public variable, such as:

For i = 1 to 10
   strAAA = strAAA & PublicVariable("strA" & i) <--- Sorry, I don't know how to do it in code..
Next i


:)Do anyone can help me? Thanks a lot...





Best Regards,
Gino Liu at CI.

Use an Array instead

Public strA(10)as string

***In Form VBA code, I wish can use For..Next loop command to reference Public variable, such as:

For i = 1 to 10
     strAAA = strAAA & strA(1)
Next i

Error in code updated.

Use an Array instead

Public strA(10)as string

***In Form VBA code, I wish can use For..Next loop command to reference Public variable, such as:

For i = 1 to 10
strAAA = strAAA & strA(1) <=== i not 1 here.
Next i