Userform Textbox Date has months and days reversed?!

[AyurvedaPura]

Hi

I have a userform with a textbox which displays a date from a userform calendar / function combo, displayed as mm/dd/yy - all good

I have a msgbox that then displays this textbox.value (mm/dd/yy), but as "dddd" & "mmmm dd yyyy" type-of-thing.

So today, displays in my textbox as 08/1/12 and should appear in the msgbox as "Wednesday August 01 2012" - but it appears as "Sunday January 08 2012" !!

So I've got a date formatted from a calendar (with a Date variable) as mm/dd/yy, displayed in a textbox as mm/dd/yy which is then read by a msgbox call to the textbox.value as dd/mm/yy

Very frustrating - how can I fix this? If I declare the date function public in the calendar form code and call it in the msgbox code would this work? or is this like taking a baseball bat to a franklin mint display?

Advice much appreciated, thanks

AP

 

[AyurvedaPura]

My days, do i have to change the regional settings (I am in the uK - dd/mm/yyyy - but I need mm/dd/yy)??

Say it isn't so!

 

[AyurvedaPura]

OK, so i am using DateValue on the textbox, and this 'uses the default date value for Microsoft Excel'

How do I change the default date value? Please let it not be regional settings!!

AP

 

[AyurvedaPura]

Help!