Home » Forums » Open Source Learning Center » Question and Answer

Dinamic Variable Memory

Submitted by AqieqS on 20 March, 2013 - 07:11

Hi All,

Is any body could help me.. ?

I have 10 variables name in a FORM, for example : Prd1, Prd2, Prd3, Prd4.....Prd10
To make calculation or adding value for all variables, is there any way to write the syntac using the FOR ... NEXT ?

For Example :

for i=1 to 10
Prd & i.value = i
next i

Regards'
AqieqS

‹ EE Solution 2 : Using a Form to Populate a Table Get Pivot table data ›
»

Hi Aqiq.I don't know if there

Submitted by AndyLitch on 20 March, 2013 - 07:35.

Hi Aqiq.I don't know if there is a way to do what you want although I'm pretty sure there is but may I suggest using an array variable

»

Dynamic Variable Memory

Submitted by AqieqS on 20 March, 2013 - 10:12.

Thanks Andy for your feedback.
As I mention before that the variable is name in UserForm.
I can make a manual calculation like total=Ps1+Ps2+Ps3.... + Ps15. But if there is a better way, why not ?
Could you share to me your suggestion to using an array ?
Looking forward your help.

Regards'
AqieqS

»

Hi Aqiq.. You use an array in

Submitted by AndyLitch on 20 March, 2013 - 14:59.

Hi Aqiq..
You use an array in a userform in exactly the same as for modules and worksheets...
The big advantage of arrays of course being that you can iterate through them .

»