Thread: Check how date is entered
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jan120253@gmail.com is offline
external usenet poster
  
Posts: 40
Default Check how date is entered
Is there anyway to check with VBA if a date is entered as DD-MM-YY or MM-DD-YY?

How can I tell using VBA if 4-5-18 is actually 4th of May of Fifth of April?

Jan
Reply With QuoteReply With Quote