VBScript - Select Case for 2 of the same options?

[humbletech99]

I have got a select case statement in which I need two or more options to be mapped to the same action, something like

Select Case strOption
    Case "abc" or "hjk"
        do something
    Case "xyz" or "sdf"
        do something else
    Case Else
        do last resort.
End Select

I really really don't want to have to have a separate Case block for each option as this would double all the code for each option.

I have checked the docs but cannot see a way of doing multiple cases at the same time.

Any guidance on this would be much appreciated.

 

[HarleyQuinn]

You can use a comma instead of the or you're currently using.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[humbletech99]

thanks that worked.

 

[HarleyQuinn]

You're welcome, glad I could help

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[markdmac]

Just want to note one thing for you, make sure you are aware that the Select Case criteria enclosed in quotes is case sensitive.

So the following are different:

Case "foo"
Case "Foo"

I hope you find this post helpful.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER. The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier! Save time, get more work done, get the Admin Script Pack.

 

[humbletech99]

yes I've noticed this, and have worked around it by Lcasing all input before the comparison... unless you know of another way?

 

[markdmac]

That is how I do it to.

I hope you find this post helpful.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER. The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier! Save time, get more work done, get the Admin Script Pack.