Excellearnerva
New Member
- Joined
- May 9, 2014
- Messages
- 7
Hi,
I am trying to set up some VBA validation on an Excel 2007 sheet, and I do not want to rely upon the NumberFormat field, in case the user has pasted into the field.
How do I check that a date is in the correct format (e.g. "dd/mm/yyyy hh:mm:ss") without using the NumberFormat function ?
Any ideas gratefully received.
I am trying to set up some VBA validation on an Excel 2007 sheet, and I do not want to rely upon the NumberFormat field, in case the user has pasted into the field.
How do I check that a date is in the correct format (e.g. "dd/mm/yyyy hh:mm:ss") without using the NumberFormat function ?
Any ideas gratefully received.
