Edate format changing to MM/DD/YYYY format

[david1987]

Hi,

In my spreadsheet I enter a date and use the EDATE function to calculate subsequent dates in the following columns.

I have created a Userform to display the data in the spreadsheet. In the Userform the initial date entered displays in the correct DD/MM/YYYY, however, the following dates which are calculated using the EDATE function are displayed in the MM/DD/YYYY format, i have no idea how to change this, any advice?

I've attached a picture of this.

Thanks

[JapanDave]

Try this, Replace Now with the date string you want format.

Please Login or Register  to view this content.

[david1987]

Sorry, that didn't work.

It accepts the dates that are manually entered, but changes the formatting of the calculated EDATE fields to MM/DD/YYYY. All of the fields have the same 'Short Date' format choice in the spreadsheet.

Any more suggestions?

The TextBoxes which are causing the issue are 'TextBox30', 'TextBox32', 'TextBox34', 'TextBox36'
'TextBox38', TextBox40', 'TextBox41', 'TextBox42'

Below is the code for my UserForm:

Please Login or Register  to view this content.

[Cutter]

@ david1987

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.