Why does the following Integer type variable output -1?

Question

Sub Test()
    Dim iX As Integer

    iX = 1 = 1

    'Out put is -1
    MsgBox iX 
End Sub

Pᴇʜ · Accepted Answer · 2020-05-05 07:15:38Z

4

Because if you compare 1 with a 1 this is True so 1 = 1 is True and True is considered as -1 in VBA by definition and you write this result into your variable iX.

This iX = 1 = 1 is evaluated the same as iX = (1 = 1) and this is iX = True and since iX is Integer the True is converted into a numeric value -1.

By definition in VBA:

True is -1
False is 0

But in Excel formulas

True is 1
False is 0

answered May 5, 2020 at 7:15

Pᴇʜ

57.9k10 gold badges55 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Why does the following Integer type variable output -1?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related