Using Or Embedded in Case statement fails

Copper Contributor

I have a case statement in VB for a spreadsheet which interrogates items.

For Readability is use Or since both case statements resulted in the same action.

 

Fails:

Case "KI-HIPP" Or "KTAP".

Works:

Case "KI-HIPP"

Case "KTAP"

 

 

The Statement work without the Or but causes serious problems with it.

 

1 Reply
The correct syntax to have a case with more than one value is:
Case "KI-HIPP", "KTAP"