Thread: or operator
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default or operator

I would use a Select Case statement. E.g.,

Select Case X
Case A
' do something
Case B
' something else
Case C
' something
' and so on
Case Else
' in case no match is found above
End Select


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Ed" wrote in message
...
What would be the correct coding syntax for the following:

If a = x then
(instructions)
or If b = x then
(instructions)
or If c = x then
(instructions)
or If d = x then
(instructions)
or If e = x then
(instructions)
or If f = x then
(instructions)
Endif


Any help would be appreciated,

Ed