hello,

Enter date cell is H2. If user tries to select and enter info in other cells before entering value in H2 (date) I would like error message to occur (which it does) but have excel return to cell H2 (which it does not).

Here is the code I have so far.

Private Sub Worksheet_Change(ByVal Target As Range)

'ENTER DATE
If Range("H2") = "" Then
MsgBox "Please enter DATE first.", vbCritical, "Error Data Entry"
Exit Sub
End If

JR