| Home |
| Search |
| Today's Posts |
|
#16
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Value in wrong format on userform
Hi,
A word of caution with the .Text property. If the column is not wide enough to display the date and instead displayed ####### that is what will be returned in the textbox. Cheers Andy Mike Woodhouse wrote: On Nov 7, 10:32 am, "Corey" wrote: I have a textbox that displays the value of a cell(E2), but the worksheet displays: 31 October 2006, yet the userform textbox value shows 10/31/06. Is there a way i can change this to display as the sheet view (31 October 2006) ? If your userform knows the address of the cell, or has a range that points to it, then the .Text property should display the date as it is seen in the worksheet... Mike -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| from date format convert to text format is wrong | Excel Discussion (Misc queries) | |||
| date in wrong format | New Users to Excel | |||
| Date in wrong format | Excel Discussion (Misc queries) | |||
| Wrong date format in header | Excel Discussion (Misc queries) | |||
| Macro gives the wrong date format | Excel Programming | |||
Threaded Mode
