Looking For a VBA Command

txgeekgirl

Registered User.
Local time
Today, 06:38
Joined
Jul 31, 2008
Messages
187
I am not sure if VBA has this capability - something like

A = PICKONE(InCode, "String 1", "String 2", "String 3", "String 4")

so that if InCode = 2 it would choose String 2

:confused:
 
Got IT

CHOOSE()

Choose(1, "Tech", "on", "the", "Net")would return "Tech"Choose(2, "Tech", "on", "the", "Net")would return "on"Choose(3, "Tech", "on", "the", "Net")would return "the"Choose(4, "Tech", "on", "the", "Net")would return "Net"Choose(5, "Tech", "on", "the", "Net")would return NULLChoose(3.75, "Tech", "on", "the", "Net")would return "the"
 

Users who are viewing this thread

Back
Top Bottom