I guess warning messages can be inserted only in the Data Validation window -> Error Alert page. Yes, the alert works only when you enter some details into the cell and press ENTER.