EXCEL VBA Check if entry is empty or not 'space' - Stack Overflow
Most terse version I can think of Len(Trim(TextBox1.Value)) = 0 If you need to do this multiple times, wrap it in a function Public Function HasContent(text_box as Object) as Boolean HasContent = (Len(Trim(text_box.Value)) > 0) End Function Usage If ......