My contiued woes with Textbox date formats

[coreytroy]

I have a column of dates in a wks formatted as dd/mm/yy.

When i use my form to populate another speadsheet with data from the sheet containing the dates, the textbox that is poulated with the date, formats the date to mm/dd/yy instead.

If i ignore the date format, and proceed with the code to place / select data from the form to the speardsheet, the cell that contains the texbox date, is then the correct format of dd/mm/yy.

So if the user does not take any notice of the incorrect date format on the form all is good, however if the date is important when selecting the required data, then the date can be off putting, as the month and day are switched the US instead of AU format.

So eg. 4 Feb 2013(4/2/13) can look like 2 Apr 13(2/4/13) instead.

I have tried to use:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

But none seem to fix the TextBox date format on the form.

[xladept]

Do you have VBA code for any of this????

[coreytroy]

Do you have VBA code for any of this????

The below is what calls for the populating of the textboxes.

Please Login or Register  to view this content.

[Norie]

Try this.

Please Login or Register  to view this content.

[coreytroy]

Try this.

Please Login or Register  to view this content.

That is what i aready have, which displays as mm/dd/yy.

[coreytroy]

Fixed it(for now i hope) and I hope it keep consistant for me.

Please Login or Register  to view this content.

seems to be working.

[nilem]

something like

Please Login or Register  to view this content.

[Norie]

Oops, I meant to replace Value with Text.:o

Using Text will return the cell value as it's formatted on the worksheet.