date format in user form
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. |
date format in user form
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. |
All times are GMT +1. The time now is 03:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com