Format text

[Wayne]

Hi,

I'm having trouble with userform I've designed.

The user enters the date into textbox1 and this is
entered into a cell, eg. A1.

The problem I have is that the date always enter the cell
in teh format mm/dd/yy, even though I have formated the
cell as dd/mm/yy. how can I correct this?

Thanks

 

[J.E. McGimpsey]

One way:

With Range("A1")
.Value = CDate(Textbox1.Text)
.NumberFormat = "dd/mm/yy"
End With