Format text

  • Thread starter Thread starter Wayne
  • Start date Start date
W

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
 
One way:

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