I would like to display the date format in the user's locale setting

[percy1984]

I'm looking for a VBA script to display a date in the locale setting of the user.
I don't mean to format a date, but to display the text "mm/dd/yyyy" for American locale settings, but "dd-mm-jjjj" for dutch locale settings.

Especially the change in character for the year is the challenging path.

Can anyone help?

[percy1984]

Wrote my own function, after some looking around on the internet:

Please Login or Register  to view this content.

[arlu1201]

percy1984,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.