Thread
:
How to evaluate VB constant name in string variable?
View Single Post
#
5
Posted to microsoft.public.excel.programming
G Lykos
external usenet poster
Posts: 74
How to evaluate VB constant name in string variable?
Thanks for the suggestion. Consistently evaluates to 0 when applied to
string variables containing
VB
constant names.
"Nigel" wrote in message
...
Try
i = VAL(sMyString)
--
Regards,
Nigel
"G Lykos" wrote in message
...
Greetings!
Example: the value of vbOkay within the VBE is 6. {i = vbOkay} yields i
= 6.
Would like a construct where {sMyString = "vbOkay" : i =
UnknownFunction(sMyString)} yields i = 6
TIA!
George
Reply With Quote
G Lykos
View Public Profile
Find all posts by G Lykos