I have tried this code in the example workbook i posted here but no msgbox appers with an invalid entry.

Could you please post the same book again with your code here so that I can see how it's done?