Menu
Note. Check if the TextBox1 is empty is easy by using TextBox1.Value = "".
But the problem is when the user hit the spacebar, TextBox1 will still recognize it as a value. In such case, my data will appear as an empty cell with 1 space inside. So my question is, is there any method to check TextBox1.value for empty and also not consist of space whether there are 1 or more space? Million thanks to all.
783
If you wish to test whether a worksheet cell is empty in VBA, you can not use the worksheet function called ISBLANK. In VBA, you must use the ISEMPTY function. In this example, we will test whether cell A1 is empty. If cell A1 is empty, the message "Cell A1 is empty" will be displayed.
Excel's IsBlank is very restrictive and will only ever give True if the cell is completely empty (not even has a formula that returns empty result). So if that returns True , IsEmpty on the cell's value should also return True. But what IsEmpty(cell) actually does is detecting whether the cell 's .
ISNULL is a built-in function in VBA and is categorized as an Information function in VBA which returns the result in Boolean type i.e. either TRUE or FALSE. If the testing value is “NULL” then it returns TRUE or else it will return FALSE.
'Empty indicates a Variant variable for which you do not explicity specify an initial value, which by default gets initialized in VBA to a value that is represented as both a zero and a zero-length string.
A common trick is to check like this:
trim(TextBox1.Value & vbnullstring) = vbnullstring this will work for spaces, empty strings, and genuine null values
84
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 HasContent(TextBox1) Then ' ... If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
