View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
brym brym is offline
external usenet poster
 
Posts: 13
Default Data form Dates wrong when called from macro?

I guess Excel refelcts to your Windows language settings while VBA uses
standard defaults.

Formatting the date value should do it. Use Help - look for 'date format'