date format in user form

[Guest]

Hi,Everybody,my code is Textbox1.value=ws.range("A2")
work sheet range A2 is a date dd-mmm-yy format,I am getting Textbox1 value
as mm/dd/yyyy format .What is the line of code to textbox1.value in dd-mmm-yy
format.

 

[Norman Jones]

Hi Tungana,

Try:

TextBox1.Value = _
ws.Format(Range("A2").Value, "dd-mmm-yy")