I have a number of String variables
strCustomer
StrAddress1
etc
These are defined via a UF and I want to use a list of the variable names to get the variable value
E.g.
B1 to show the strCustomer variable value where A1 contains the string strCustomer
B2 to show the strAddress1 variable value where A2 contains the string strAddress1
I thought using some thing like the following would work
The code to add the variable values to the worksheet take place outside the UF code after the UF has been unloaded.
TIA
strCustomer
StrAddress1
etc
These are defined via a UF and I want to use a list of the variable names to get the variable value
E.g.
B1 to show the strCustomer variable value where A1 contains the string strCustomer
B2 to show the strAddress1 variable value where A2 contains the string strAddress1
I thought using some thing like the following would work
VBA Code:
Range("B1") = Variable(range("A1"))
The code to add the variable values to the worksheet take place outside the UF code after the UF has been unloaded.
TIA