PDA

View Full Version : CallByName Fucntion



JuniorASA
11-19-2006, 04:54 AM
I would like to call different module. For example, module1, module2 and module3.

Instead of call it one by one. I would like to call it in the for next loop. I.e.

For i = 1 to 3

Call "Module" & i

Next i

However, the call function cannot use for variable name. I learn that what I need to use is CallByName function. However, I cannot find an appropriate example from help. Is there any example to share with me for the CallByName function??

Many Thanks,

Bob Phillips
11-19-2006, 05:55 AM
For i = 1 to 3

Application.Run "Module" & i

Next i