| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date format changes when inputed from user form | Excel Discussion (Misc queries) | |||
| visual basic user form date format dd/mm/yy not mm/dd/yy | Excel Discussion (Misc queries) | |||
| Number Format Controls on a User Form | Excel Programming | |||
| how to format a date/validate for a text box entry on a user form | Excel Programming | |||
| Cell format and User form question | Excel Programming | |||
Linear Mode
