Thread: How to evaluate VB constant name in string variable?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_3_] Nigel[_3_] is offline
external usenet poster
  
Posts: 31
Default How to evaluate VB constant name in string variable?
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 QuoteReply With Quote