UK format date in userform textbox

[djamieson18]

Hi All,

I am having trouble with the uk date format in vba. I am using excel 2010 on windows and have changed my regional settings.

My textbox is called custom_date and to have the date appear when the userform is launched, I enter the following code:

UserForm1.custom_date.Format = Date

This works but gives me the date in US format i.e. mm/dd/yyyy. Even if I make the above code refer to a cell in uk format date, it still changes it to US format.

Any ideas?

 

[VoG]

Try

= Format(Date,"dd/mm/yyyy")