Indirect Reference to a Variable in VBA

[Arul.rajesh]

I have a list of values which are names of arrays

Something like

 CDS=Array(CIPR,CIPW,PTPA,CSRP,CITR,CPER,CPCT,CPSC,CW9D,VMLE,VMAD,AUTH,AUTE,AUTB,AUTL,NMRC,NMRE,NMRF,NMFR,CDTF,DTFA,CDTE,CNOF,CFWA,CDED,CDES,DEDR,CCOB,PEOB,CCOD,BMAX,MAXS,CNCS,CNPI,CFAX,CAPP,DEFA,CPEE,CPFL,CFWU,CFWE,CCAP,AUTW,CITW,CIPE,CDUP,CPNL,BMBS,ADDI,POSR,CLIC,CLIA,COIN,HOSP,OONP,POST,PPMX,PPMD,PROV)

Each four digit string is an array.

The user selects an option from a ComboBox

I need to Set the value of a another variable to an element in the array referenced by the "CODE" the user selects.

The problem is the selected text is a string.

I can loop through all the codes and check if the user has selected which "CODE", if I have the name of the array as the first element in the array.

 

[pgc01]

Hi Arul

What you want is not allowed by the vba syntax.

The closest I see would be to use something like an associative array. You could use a Collection or a Dictionary object to implement it.

Notice that in this case you'd create the association of the arrays with the strings at the beginning of the execution. You would then have a direct access to the arrays using the strings during the rest of the execution of the program.

 

[Arul.rajesh]

Hi Arul

What you want is not allowed by the vba syntax.

The closest I see would be to use something like an associative array. You could use a Collection or a Dictionary object to implement it.

Notice that in this case you'd create the association of the arrays with the strings at the beginning of the execution. You would then have a direct access to the arrays using the strings during the rest of the execution of the program.

I did do something like that

In the arrays I set the first element as the name of the array, then looped through all the arrays to check for a match with the first element to locate the required array.

I have 59 arrays defined like this, so it is pretty fast for now.

Thank you everyone for your Help.