| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform date format problem
Hi,
I am having a problem with the date formatting in a user form text box in excel 2000. For example: If in the text box you type: 03/12/04 for the 3rd december 04 The following code writes the date back to the active cell ActiveCell.Value = Format(Me.txtDate.Value, "dd/mm/yy") However this writes 12/03/04 onto the worksheet. How do I get it to recognise that 03 is the day and 12 the month? Thanks Jenni -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform date format problem
Hi jennie .
I suggest to use a calandar control http://www.rondebruin.nl/calendar.htm -- Regards Ron de Bruin http://www.rondebruin.nl "jennie " wrote in message ... Hi, I am having a problem with the date formatting in a user form text box, in excel 2000. For example: If in the text box you type: 03/12/04 for the 3rd december 04 The following code writes the date back to the active cell ActiveCell.Value = Format(Me.txtDate.Value, "dd/mm/yy") However this writes 12/03/04 onto the worksheet. How do I get it to recognise that 03 is the day and 12 the month? Thanks Jennie --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform date format problem
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Format for Userform TextBox | New Users to Excel | |||
| Format problem in displayed userform | Excel Worksheet Functions | |||
| Need A date Mask format for a Textbox on UserForm | Excel Discussion (Misc queries) | |||
| Restrict date format for UserForm | Excel Discussion (Misc queries) | |||
| Userform Textbox - Date Problem | Excel Programming | |||
Linear Mode
