excel macro check if cell is empty code example

Example 1: excel check if cell not empty

IF(A1<>"","Not empty","Empty")

Example 2: excel vba check cell not empty

'VBA to check if cell A1 has a value.

'Two different ways...

MsgBox Not IsEmpty([A1])

MsgBox Not Len([A1]) = 0