Logic behind If Not Selection.Value > "" ?

[Krisz06]

Hello, it will be a stupid question most probably...

Why in VBA we are using the following:
"If Not Selection.Value > ""

If I'm correct that this basically means "if selection value is not bigger than nothing", which mean if value is 0..
There is no "If Selection.Value = "" for this or why the more complicated one is the used?



I'm a beginner and has no programming background, so this may be some obvious thing, but I'm just confused about it.
But how I see this code in a lot of places I assume that this it the VBA logic and I just need to get used to it

 

[Roxxien]

I have never see the first criteria in my life ...

Normally we use "If Selection.Value <> "" Then" or "If Selection.Value = "" Then"

The not argument is more used in situation with True or False formula like IsNumeric or IsEmpty.

I had like to know where you often see this. In fact, it's not testing for "bigger than 0" but "bigger than nothing". What can be bigger than nothing?

 

[Krisz06]

Thank you for your reply Roxxien,

Sorry, I haven't put the whole sentence in the original post. The full looks like this:
If Not Selection.Value > "" Then Exit Do


So, thanks for the clarification that "If Selection.Value = "" Then" is also used in vba..
I was checking it from the Mr Excel book and also from various google searches and I saw always this logical twist with the "Not"... so now I understand


And just checked the following 3:
If Not Selection.Value > "" Then Exit Do
If Selection.Value = 0 Then Exit Do
If Selection.Value = "" Then Exit Do
give the same result. I will use the middle one in the future