ExcelBanter - Data form Dates wrong when called from macro?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Data form Dates wrong when called from macro? (https://www.excelbanter.com/excel-programming/272968-re-data-form-dates-wrong-when-called-macro.html)

brym

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'

All times are GMT +1. The time now is 05:23 PM.