https://stackoverflow.com › questions › 46006679

vbNullString is essentially a null string pointer. Debug.Print StrPtr(vbNullString) 'prints 0. It looks equivalent to a literal "" empty string, but it's not: Debug.Print StrPtr("") 'prints an address; 6 bytes are allocated for it.

https://stackoverflow.com › questions › 32435320

For most purposes, vbNullString is equivalent to "" in VB. The only practical difference is that vbNullString is faster to assign and process and it takes less memory. If you call some non-VB API or component, test the calls with vbNullString before distributing your application.

https://forum.excel-pratique.com › excel › vbnullstring-23130

vbnullstring est une constante qui équivaut à rien --> donc ceci --> " ". Exemple : tu peux écrire : If Range("A1") = vbNullString Then MsgBox "CELLULE VIDE. ".

https://www.vbforums.com › showthread.php

The vbNullString constant can be used to return a distinct null value from your own String valued Functions too. It has a role similar to that of the Variant Null value returned from database fields. That's the other role of vbNullString: parameters passed to API calls that distinguish a null String value from a 0-length value.

https://devtut.github.io › vba › string-literals-escaping-non-printable-characters-and...

Using vbNullString is considered better practice than the equivalent value of "" due to differences in how the code is compiled. Strings are accessed via a pointer to an allocated area of memory, and the VBA compiler is smart enough to use a null pointer to represent vbNullString.

https://www.mrexcel.com › board › threads › vbanullstring-empty.625494

vbNullString is a compiler constant that refers to a zero-length string. A cells with a formula that returns a null string ("") has the same value as vbNullString. Empty is the state of an uninitialized Variant, or one that is explicity set to Empty. IsEmpty(Range("A1").Value) or VarType(Range("A1").Value) = vbEmpty tests whether a ...

https://nolongerset.com › check-for-empty-strings-in-vba

The two types are functionally equivalent in VB, but vbNullString is preferred because it doesn't require any memory. My Personal Preference. I use Len(strTest) = 0 in my own code. For high-performance string-handling code, use LenB(strTest) = 0.

https://www.mrexcel.com › board › threads › isnull-vs-vbnullstring-vs-isempty.616401

IsNull and IsEmpty are Excel-defined functions that return either a true or false. i.e. If IsNull (var1) then 'do something. whereas vbNullString is an Excel defined constant that for simplicities sake is the same as "". So If var1 = vbNullString then 'do something.

https://excelbaby.com › learn › the-difference-between-empty-null-and-nothing-in-vba

vbNullString is a constant, which represents an empty string. It is different from the blank string "", which means nothing string. For many occasions, it is treated as an empty string "", the real purpose of using it is to pass a null parameter to the library function.