How to evaluate VB constant name in string variable?
in [Programming]
|
From: G Lykos on 11 Feb 2010 00:58 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
From: Nigel on 11 Feb 2010 03:50 Try i = VAL(sMyString) -- Regards, Nigel nigelnospam(a)9sw.co.uk "G Lykos" <GLykos(a)CompuServe.com> wrote in message news:%23iVJr8tqKHA.3408(a)TK2MSFTNGP06.phx.gbl... > 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 > >
From: Peter T on 11 Feb 2010 08:13 What's the context of your question vbOkay - no such named constant, maybe you mean vbYes/6 or vbOK/1 Regards, Peter T "G Lykos" <GLykos(a)CompuServe.com> wrote in message news:%23iVJr8tqKHA.3408(a)TK2MSFTNGP06.phx.gbl... > 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 > >
From: G Lykos on 11 Feb 2010 10:56 Okay - how about vbOK/1. Are you familiar with a mechanism to evaluate the VB constant name in a string variable? Thanks! "Peter T" <peter_t(a)discussions> wrote in message news:eYKRNwxqKHA.4284(a)TK2MSFTNGP04.phx.gbl... > What's the context of your question > > vbOkay - no such named constant, maybe you mean vbYes/6 or vbOK/1 > > Regards, > Peter T > > "G Lykos" <GLykos(a)CompuServe.com> wrote in message > news:%23iVJr8tqKHA.3408(a)TK2MSFTNGP06.phx.gbl... >> 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 >> >> > >
From: G Lykos on 11 Feb 2010 11:15 Thanks for the suggestion. Consistently evaluates to 0 when applied to string variables containing VB constant names. "Nigel" <nigel(a)no9swspam.co.uk> wrote in message news:uNyLDdvqKHA.6064(a)TK2MSFTNGP02.phx.gbl... > Try > > i = VAL(sMyString) > > -- > > Regards, > Nigel > nigelnospam(a)9sw.co.uk > > > > "G Lykos" <GLykos(a)CompuServe.com> wrote in message > news:%23iVJr8tqKHA.3408(a)TK2MSFTNGP06.phx.gbl... >> 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 >> >> >
|
Next
|
Last
Pages: 1 2 Prev: using lookup function in vba Next: Macro needs to rename worksheet tab name |