VBA to Change Date Format

[srj1359]

Hello! I work for a global company and have a workbook used by colleagues in multiple countries. Is there a way to write VBA for a popup so that the date format changes based on the user's country? Ex: in the United States, we write December 18, 2020 and 12/18/20, but other regions write 18/12/20. Any assistance you can provide is greatly appreciated! Thank you,

 

[JLGWhiz]

The date should appear on a user's pc according to their country setting on their equipment. The date value is a long integer and the default format that is displayed as the short date, (ie. mm/dd/yyyy) is determined by the system setting through Control Panel. You should not have to be conserned about the display format. However, it does not automatically convert literal dates used in code, so you have to be careful about how you express dates in the code.

This link might be helpful: How To: Regional Date Formats in Excel Update: December 2020 Microsoft Excel Tips • Excel Semi-Pro