Hello Everyone,
I have list of string say "Apple","Mango","One","India","USA" ... list goes on..
I have to check if the user input is present in this list.
I am looking something like:
IF strUserInput in ("Apple","Mango","One","India","USA") THEN
MSGBOX "Found"
ENDIF
What is the most efficient way to do this in VBA?
Regards,
Yeheya
I have list of string say "Apple","Mango","One","India","USA" ... list goes on..
I have to check if the user input is present in this list.
I am looking something like:
IF strUserInput in ("Apple","Mango","One","India","USA") THEN
MSGBOX "Found"
ENDIF
What is the most efficient way to do this in VBA?
Regards,
Yeheya