Evaluating Multiple Expressions in an If Statement

It is common to have multiple expressions in an If statement using logical operators And, Or, etc. Remember that every expression in the If statement will always be evaluated, even if a previous expression renders the entire statement False. This could cause an unexpected error in certain situations.

'
' Even if x=0 the second expression will be evaluated
' raising a divide by 0 error.
'
If (x > 0) And (y / x > 1) Then
        ' Do something here
    End If

'
' Separate the expressions to avoid a divide by 0 error.
'
    If (x > 0) Then
        If (y / x > 1) Then
            ' Do something here
        End If
    End If

EnvisionCAD

Since 1996, EnvisionCAD has been a nationally recognized leader in the configuration, customization, implementation, training & support for CAD software solutions. Our individualized approach has benefited private engineering firms and government agencies alike. Basic or advanced, we can help you get the most from your CAD technology.