StrComp numeric

[Guest]

When using this VB function :
If StrComp(Target.Offset(0, -3).Text, "Debit", vbTextCompare) = 0 Then

How do I turn it into a numeric test?

 

[Guest]

If you want to compare two numbers

If target.Offset(0,-3).Value > 21 then

If you mean case sensitive
replace vbTextCompare with
vbBinaryCompare

Natrually strcomp is for comparing strings.

 

[Guest]

Thanks Tom: I was thinking in the same direction, but did not realize .value