IsNullString – Check whether a string contains white-spaces

' Return True is a string is made only of spaces, tabs, and Null characters.' This function is especially useful to test whether fixed-length strings ' are initialized.Function IsNullString(Text As String) As Boolean    Dim i As Long    For i = 1 To Len(Text)        Select Case Asc(Mid$(Text, i, 1))            Case 0, 9, 32            Case Else                Exit Function        End Select    Next    IsNullString = TrueEnd Function

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: