Zani,

For a previous posting (thanks to Tom Ogilvy):

Private Sub textbox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Range("a1") = CDate(TextBox1.Text)
Range("a1").NumberFormat = "dd/mm/yy"
End Sub

I am UK-Based and share your frustration.

HTH

End Sub"Zani" wrote:

Hi, no that's not it. the cell formats are OK, it is something weird to do
with VB being in US format, and I am working in UK format - am so confused!!!!
--
Zani
(if I have posted here, I really am stuck!)



"Yngve" wrote:

Hi Zani

You have to set right format on cells

Regads Yngve