Date Problems in userform

[pejabe]

what I'm having problems with is that I have UK dates in excel spreadsheet and they are dd/mmm/yyyy but some dates when I transfer them to a userform ends up US format when I show the information this userform gets used by number of users .

I have tried number of things but nothings working .Text = Format(Reg65, "dd/mmm/yyyy")

any help would be nice

[ranman256]

changing the cell format to : "dd/mmm/yyyy", doesnt work?

you can try some vb code, to alter the US fields to your column...
range("B2").value= format(range("Z2").value,"dd/mmm/yyyy")

[Norie]

How are you currently transferring the dates from the sheet to the userform?

If you want any cell value to appear as it's formatted on the worksheet then use it's Text property, for example.

Please Login or Register  to view this content.

Note, when putting values from the userform to the sheet don't use Format as that converts to string, instead use the conversion functions like Val, CDate, DateValue etc.

[pejabe]

Thanks for your replies.
all information on the spreadsheet get all sorted via userforms either adding information or viewing information.
This is the code I'm using to transfer from sheet to userform

Please Login or Register  to view this content.

[Norie]

Try this for a start.

Please Login or Register  to view this content.

That should at least get the values from the worksheet as they are formatted on the worksheet.

[pejabe]

sorry for late reply not been in office to try until now, I would like to thank you Norie its working at the moment but only tried on two machines at present.