Select Case 1

[SteveCarrier]

Hello,

I am using a select case for a project where some cases will have the same result, i.e. if x = 2 or 4 then the same lines of code are applicable.

ie.

Select Case strValue
Case 1 or 2 or 12 <------this doesn't seem to work
--do these lines of code--
Case 3 or 4 or 5 or 6
--do these lines of code
End Select

I am not sure if the syntax is right?

Thanks in advance.

Steve Carrier

 

[bdmclennan]

Steve,

Try this.

Select Case strValue
Case 1 , 2 ,12 '<------this doesn't seem to work
' --do these lines of code--
Case 3 to 6
'--do these lines of code
End Select

All the best

B.