VBA Date to DD/MM/YYYY

**awoolfe** · 07-22-2021, 07:18 AM

I have a textbox in a userform where a date can be added. To make sure it is in DD/MM/YYYY format I use CDATE function. e.g. .Range(1) = CDate(Me.DATE.Value).

However:
1) If I leave this textbox empty it results in an error message as there is no date input.
2) If I remove the CDate function e.g. .Range(1) = Me.DATE.Value, it results in MM/DD/YYYY.

My excel is set to UK date mode.

How do I make it optional to enter a date in the textbox AND for it to be in DD/MM/YYYY format?

Thanks!

**TMS** · 07-22-2021, 07:30 AM

Try:

Please Login or Register  to view this content.

**awoolfe** · 07-22-2021, 07:56 AM

Thanks TMS!! Works perfectly in my spreadsheet

**TMS** · 07-22-2021, 08:03 AM

You're welcome. Thanks for the rep.

VBA Date to DD/MM/YYYY

LinkBack

Thread Tools

Rate This Thread

Display

VBA Date to DD/MM/YYYY

Re: VBA Date to DD/MM/YYYY

Re: VBA Date to DD/MM/YYYY

Re: VBA Date to DD/MM/YYYY

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Multi Column Listbox returning date as mm-dd-yyyy instead of dd-dmm-yyyy

[SOLVED] Change existing date from mm/dd/yyyy to dd/mm/yyyy format without changing the position

I want excel to show me date in the form of yyyy.mm without showing 01/01/YYYY in the tab.

Change of date format from Excel2010 to Excel2013 (dd/MM/yyyy to dd-MM-yyyy)

VBA Macro to capture DATA in dd/mm/yyyy even though system date format is mm/dd/yyyy

[SOLVED] Imported data contains strings dd.mm.yyyy how can I convert to date format dd/mm/yyyy inVB

[SOLVED] opening excel file -> date format problem: DD/MM/YYYY vs MM/DD/YYYY

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions