Assignment Vs Condition

[georgiboy]

That will return a Boolean, in the example above that would return FALSE as 6 does not equal 5.

You would use this for doing a comparison and returning TRUE/ FALSE.

Take the below for example, in the first part of the code: 6 and 5 don't match so you get a FALSE
In the second part 5 and 5 do match so you get a TRUE:

Sub test()
    Dim b As Boolean
    
    b = 6 = 5
    Debug.Print b
    
    b = 6 = 6
    Debug.Print b
End Sub