Using the VBA Len function to test for empty string values will improve the performance of your applications.


Dim strValue as String

'
' Typical method to test for empty string
'
If strValue = "" Then
MsgBox "String is empty"
End If

'
' Quicker method to test for empty string
'
If Len(strValue) = 0 Then
MsgBox "String is empty"
End If