Share via

Test for missing data

Anonymous
2023-05-05T21:19:31+00:00

I have a UserForm. I want to test for missing data when I click on the continue button.

In MS Access vba it would look like the code below. But seems that vba in Excel runs differently. Any thoughts on how I can achieve the same result?

    If IsNull(txt\_Start) Then 

        MsgBox "You must enter a Start Date" 

    End If
Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2023-05-05T21:34:57+00:00

Use

    If Me.txt_Start = "" Then

        MsgBox "You must enter a Start Date!"
    End If

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest