Posted by lucky on January 21, 2002 7:15 AM
I have a Userform that AutoOpen's when the file opens that has a number of text boxes that require input by the user. One of the text boxes requires a date input in the format dd/mm/yy and has the contol source set at Sheet1!A1. I have cell A1 date formated dd/mm/yy, but when I input a date (e.g 01/04/02) into the text box, the cell A1 returns the date in mm/dd/yy format (e.g 04/01/02)
Is there any way I can format the textbox maybe? Or any other ideas??