How to sum or deal with True and False

Question

Hello everyone

I am confused of how to use True and False in the sum process ...

I mean for example: In the immediate window if I typed 2 + True I got 1 >> I expect to get three as True equals to 1 but I got 1

At the same time I tried in the immediate window to type 2 + False and I got 2 >> and this is logical for me as False equals to 0 so 2 + 0 = 2

 

Any idea?

Answer 1

I have searched and found this link

https://bettersolutions.com/vba/data-types/boolean-data-type.htm

It seems that True equals to -1 in VBA not equals to 1 as in using it in worksheet. So it is now logical for me

Comments

That is correct! Although it's atypical, the Boolean True equals -1 in VBA, VB.NET and Visual Basic

---

Thank you very much my tutor.

Answer 2

I had to do something similar a while back and found that using Abs(True) fixed the issue for me. That gave me the value of +1 that I needed.

Comments

The currently selected answer explains WHY the behavior exists, but I like this practical answer better. :)

Probably because I do the same thing!

Cheers,

Mitch