I need to Prevent Users from Moving to Next Row w/out Entering a Certain Cell

[Terrapin69]

In my Excel Sheet, I have a column "X" - Is there a formula that I could use/a "macro" or script that would prevent users (or at least display a pop up warning) from entering data in the next row without entering a value in that cell?

[Special-K]

Try Data Validation on the Data tab.
You can set formulas and warnings if they don't enter the correct data.

[Terrapin69]

Thanks - I was playing around with that but really want something more like a macro - The desired input is a US Zip Code.

I tried this macro but it only prevent "saving or closing" the workbook - Really looking for something that will prevent the user from moving on ...

If Cells(e2).Value = "" Then

MsgBox "Cell e2 requires user input"

Cancel = True

End If