clairedon
10-12-2006, 03:30 AM
Please Help!
I have Excel spreadsheets, and a VBA form that takes input from the user and adds it to the Excel form. My problem i'm sure is a simple one, but its bugging me. I enter the date format in the text box as dd/mm/yyyy, and want it to print in the spreadsheet as same, however it prints as mm/dd/yyyy. Does anybody know what i'm doing wrong?
Thanks in advance
I have Excel spreadsheets, and a VBA form that takes input from the user and adds it to the Excel form. My problem i'm sure is a simple one, but its bugging me. I enter the date format in the text box as dd/mm/yyyy, and want it to print in the spreadsheet as same, however it prints as mm/dd/yyyy. Does anybody know what i'm doing wrong?
Thanks in advance