| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date format changes when inputed from user form
Hi, I have a user form which contains text boxes into which I type the
date in format dd/mm/yy. However when I click on the enter button and the data is entered onto my spread sheet the date enters as mm/dd/yy. I can get it to enter in the correct format if I use a calendar to add the date but I dont want to do this If I can help it. Is there an easy solution to this problem. I have spent hours trying to get it right but nothing Ive tried works. Thank you for any assistance L |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Restricting user to enter the date in a particular format only ! | Excel Discussion (Misc queries) | |||
| How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
| visual basic user form date format dd/mm/yy not mm/dd/yy | Excel Discussion (Misc queries) | |||
| How do I formate cells in excell to show inputed date as 09/13/ | Excel Worksheet Functions | |||
| VBA: Return Searched Value Inputed by End-User | Excel Worksheet Functions | |||
Threaded Mode
