Sub cmdIfThenElse() Dim txtName As String Dim txtAge As String If IsNull(txtName) Or IsNull(txtAge) Then msgBox "Name or Age is Blank" Else msgBox "Your Name Is " & txtName & " And Your Age Is " & txtAge End IfEnd Sub