Select the case

As SoggyP says, use Select True and then have each Case as you would an If statement.

You can't use To with Case, but you can have the 'pick several' option that you mentioned.