Is this cheating?:
Sub blah()
Dim val As New Collection
val.Add "apple", "val1"
val.Add "banana", "val2"
val.Add "carrot", "val3"
TestVar = "Val2"
MsgBox val(TestVar)
End Sub
--- In ExcelVBA@yahoogroups.com, "paulschreinerindy" <schreiner_paul@...> wrote:
>
> I have a co-worker that has come to me with a question.
> I'm pretty sure I've done this in the past, but
> I cannot seem to locate it in my 80,000 lines of VBA code!
>
> We have several variables:
> Val1 = "apple"
> Val2 = "banana"
> Val3 = "carrot"
>
> there is another variable that will result in
> having the value of one of these variable NAMES.
>
> TestVar = "Val2"
>
> How do we determine the value of the variable
> represented by the value of TestVar?
>
> That is: msgbox val(TestVar)
> displays: "banana"
>
> (similar to the INDIRECT() function in Excel, but for variables)
>
> Paul
>
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar