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 yyyymmdd and could either be entered or pasted as a block of cells. i.e. It would be necessary to cycle thorugh the data.
A message box should appear if any invalid data is found and the option to clear the individualy cell with the bad entry or cancel the entire input provided.
Is this possible? Can anybody provide the VBA code for me to test?
Bookmarks