Can you have a compound select case construction?

[max3732]

I know the normal format, but can't figure out how to do a compound statement like you can with the "If statement". With the "If" statement you can use the word "and" between the conditions.

With select case is there an equivalent or you can you only do one case at a time?

For example...

Select Case j
Case (is <= opVac and is <=rMths)
end select

[jolivanes]

Is this what you mean?

Please Login or Register  to view this content.

If any of the 4 cases is true it will do it's thing.

Or you can do a Select Case within a Select Case

[rorya]

You can also use a Select Case True construction, but I don't generally see any point in using Select Case over If for a situation like that.

[max3732]

Is this what you mean?

Please Login or Register  to view this content.

If any of the 4 cases is true it will do it's thing.

Or you can do a Select Case within a Select Case

Yes, but would it also work for numerical comparisons?

[jolivanes]

Re: "Yes, but would it also work for numerical comparisons?"
What happened when you tried with (no need for the UCase)?
Case 2, 4, 6 ,8

[LJMetzger]

Off topic but related.

I have had problems in the past with the following construction @jolivanes used in post #2:

Please Login or Register  to view this content.

The UCase occassionally did not get interpreted properly. My speculation is that 'Select Case' is expecting a a value.

I usually use the following in its stead.

Please Login or Register  to view this content.

Lewis

[max3732]

Thanks for explaining! I'm stuck on this array part now that comes before the place I'd need this, but will come back to it.

[jolivanes]

Thanks Lewis.
I just copied that code from something I had.
Thank you for showing/correcting me.