if ... or ... then ?
 

In vba can you have an if ... then in the format if "x" or "y" then?

if ... or ... then ?
 

Max,

You can write your code in a way similar to the following:

If X = something Or Y = something_else Then
' do something
Else
' do something else
End If

If both X and Y are boolean variables (or if they are numeric and you want
to test whether either is not equal to zero), you can simplify the If
statement to

If X Or Y Then


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Max Bialystock" wrote in message
...
In vba can you have an if ... then in the format if "x" or "y" then?