Select Case and Arrays?

[hypnotoad]

I'm trying to make a select case statement that would execute certain code depending on which array a user entered text string is stored in. I'm not using the code tag because I'm abbreviating (I hope that alright)...

Case Array1
do this
Case Array2
do this
etc...

I've tried a few ways of of writing the case statement, but Excel is not liking any of them. Is what I'm trying to do futile?

 

[pgc01]

You're welcome. Thanks for the feedback.

Remark: you could, of course, reverse the logic:

...
 
Select Case True
 
    Case IsNumeric(Application.Match(sLookupValue, vArr1, 0))
        sOption = "One"
 
...

 

[hypnotoad]

Yeah that's pretty neat! I probably would know these things but I have no formal training in any programming language. Thanks again, I really appreciate it.

 

[pgc01]

I'm glad it helped. Cheers!

 

[Kyle123]

A slightly different approach

Sub anotherway()
    
    Select Case Sheets("List").Cells(2, 1).CurrentRegion.Find(UserForm1.tag, Lookat:=1).Column
        Case Is = 1: MsgBox ("Array1")
        Case Is = 2: MsgBox ("Array2")
        Case Is = 3: MsgBox ("Array3")
    End Select
    
End Sub