Strange result.. what am I missing ?

[AlexanderBB]

Rtype is an integer = 10

Debug.Print RType And 1.

Result = 0 and I believe this is correct

rtype= 1010
1 = 0001
Result 0000

But in code my next line is 'If RType And 1 = 1 Then '.... and it executes the Then clause even though RType And 1 is not 1.

Why would this be ?

Thanks, ADKM

 

[StephenCrump]

Try: If (RType And 1) = 1 Then

A roundabout way of checking odd/even, or just testing for something bigger?

 

[AlexanderBB]

Thanks Stephen - sanity restored I'm using it with 4 checkboxes to action just those ticked. Probably more/better
ways but this seemed suitable... then bugged the hell out of me when it wouldn't work.