MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Date Formats in Text Boxes


Posted by Colin Macleod on May 08, 2001 6:28 AM

When entering a date into a Text Box on a User Form, the date is automatically converted to the US format mm/dd/yy even though the Control Source on the worksheet is formatted to dd-mmm-yy. Why is this - and how do I get the text box to display dd-mmm-yy? My Regional Settings are OK.
Thanks


Posted by GREG on May 08, 2001 7:41 AM


response
textbox = format(textbox,"dd-mmm-yy")