MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Date Format

Posted by Tee on April 17, 2001 3:03 PM

Hi Everyone

I am using a userform textbox to enter data into a spreadsheet. I have the user enter the date as dd/mm/yy. Sometimes the date once enteried into the cell is dd/mm/yy and if you double click in it the format is dd/mm/yyyy. Other times it is dd/mm/yy. Can anyone suggest a solution so that the date format remains dd/mm/yy for every entry.

Thanks in advance

Posted by gregc on April 17, 2001 3:49 PM

textbox = format(textbox,"MM/DD/YY") This will make the date the proper format all the time in the textbox on the form.