According to VB6 testing for an empty string is faster when done this way.
LenB(Text$) = 0
Rather then
Text$ =
LenB the byte equivalent of Len is faster than Len and the test for an inequality is faster than a greater then or less than sign. LenB never returns a neg number.
Testing for Text$ = "" takes 6 bytes of RAM each time you use it. A VBA string is only a pointer to a character array. The address in memory pointed to by this variable points to the start of a character array. The array is preceded by 4 bytes showing the length of the string in bytes, and terminates with a 2-byte null terminator. So using a "' to declare an empty string results in a array size of 0 and will contain the 4 byte length data, and the 2 byte terminator
VbNullString still returns a pointer but one that does not point to any character array resulting in no 4 byte length field or 2 byte terminator.
VbNullString is a string having a value of 0 and is not the same as a ZLS