View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
G Lykos G Lykos is offline
external usenet poster
 
Posts: 74
Default 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