Thread: VBA Setting .Value to a date does not respect local system setting
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Frank_Hamersley Frank_Hamersley is offline
external usenet poster
  
Posts: 12
Default VBA Setting .Value to a date does not respect local system setting
"William" wrote

Try using "DateSerial" [ DateSerial(Year, Month, Day) ]

Thanks - but I have no problem if I cast the value myself - only if I leave
it to Excel.

Cheers, Frank.


Reply With QuoteReply With Quote