I have a user form which has some textboxes on it which the user fills in information which is then entered into a spreadsheet. 2 of these textboxes are used to input dates however I have noticed an issue which I have never noticed before. When a date is entered in the format dd/mm/yyyy, if the day value is less than 13 then when the date is entered into the spreadsheet it is entered as mm/dd/yyyy. I have tried altering the format of the cells and other things but I cannot rectify this issue. Anybody got any ideas?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Date format issue when using Forms
- Thread starter ETSLtd
- Start date
-
- Tags
- date format issue
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
Welcome to MrExcel.
Use the DateValue function which is locale aware. Example:
Range("A1").Value = DateValue(TextBox1.Text)
Use the DateValue function which is locale aware. Example:
Range("A1").Value = DateValue(TextBox1.Text)
Last edited:
Upvote
0
