Hi Tungana,

Try:

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


---
Regards,
Norman



"TUNGANA KURMA RAJU" wrote in
message ...
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.