Display warning message but allow to continue

[jwasten]

I have a method to check certain cells in a worksheet to be sure they are populated before the user can save and/or deactivate the worksheet. If those cells are not populated, a message is displayed AND the user is not allowed to continue until corrective action is taken.

Is there a way to only display a message if a certain value (zero) is in a cell but allow the user to continue and possibly save or deactivate the worksheet? (I'm already using the validation input message field for all these cells.)

Thanks!

 

[James]

If your not opposed to vba

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error Resume Next
If [A1] = 0 Then
MsgBox "Are you sure you want to leave this at 0?,vbOKOnly
End If
On Error GoTo 0
End Sub

HTH
James