'And' condition evaluated even if previous condition is false in VBA

Question

For example:

Dim name As String: name = "NaN"

' Doesn't generate an error:
If IsNumeric(name) Then
    Dim iv As Integer: iv = CInt(name)
    If iv > 0 Then
        ' Do something
    End If
End If

' Does generate error 13 on 'CInt(name)': Types don't match
If IsNumeric(name) And CInt(name) > 0 Then
    ' Do something
End If

Why is the second condition CInt(name) > 0 even evaluated with the single if statement? Or is this just what VBA does? I'm used to write C# code which doesn't have this kind of behavior.

see [vba short circuit logic](http://stackoverflow.com/questions/7015471/does-the-vba-and-operator-evaluate-the-second-argument-when-the-first-is-false) — amdixon, Sep 26 '15 at 11:03

score 2 · Accepted Answer · edited May 23 '17 at 12:22

2

Or is this just what VBA does?

Yes.

Use this instead:

If IsNumeric(name) Then 
    If CInt(name) > 0 Then
        ' Do something
    End If
End If

or any other method from the post linked by amdixon.

edited May 23 '17 at 12:22

Community

1
1

answered Sep 26 '15 at 11:27

Andre

26,751
7
36
80

I see. Too bad that you can't use C# in Excel to write macros :( – Kapé Sep 26 '15 at 14:02

'And' condition evaluated even if previous condition is false in VBA

1 Answers1