Hi,

I would like to check the format of dates entered or pasted into a Excel Spreadsheet column with VBA code.
The date format must be DD/MM/YYYY. A message box should appear if any invalid data is found and the option to clear the individually cell with the bad entry or cancel the entire input provided.

This issue same as the following question. But, onlty difference is, in here date format should be "DD/MM/YYYY".

https://www.excelforum.com/excel-pro...-vba-code.html

Could you please provide the VBA code for me to test?