Simple VBA Question

[TheJenson]

I just have one quick question, i searched around the internet and couldn't find it, and even looked in my handy dandy VBA programming manual and couldn't find it. I don't know what this means "<>"

For example:

Do Until userName <> " "

I don't understand the condition, can someone out there clarify for me?

Thanks!

 

[Rick Rothstein]

The less than symbol followed by a greater than symbol is the way you say "not equal to" in a comparison expression (such as is found in an If..Then statement). The code line you posted says Do Until the variable username is "not equal to" a blank space... which, by the way, would be an unusual test as most times the test would be against "" (the empty string).

 

[Warship]

"<>" means NOT equal to

Do Until userName <> " "

will also have Loop to end the Do

In this case the loop continues until userName is NOT equal to " " (a space)

 

[TheJenson]

Thank you! I thought it would be something like that but was unsure, appreciate the help.