| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date formatting issue in user form
Well for umpteenth time I have a question,
I would like the user to be able to type 041505 hit enter or tab and in the user form now show the date as o4-15-05. The following is what I have attempter thus far. Thank you! Private Sub txtDate_Enter() txtDate.Value = Format(Me.txtDate, "") End Sub Private Sub txtDate_Exit(ByVal cancel As MSForms.ReturnBoolean) txtDate.Value = Format(Me.txtDate.Value, "dd/mmm/yy") End Sub -- Though daily learning, I LOVE EXCEL! Jennifer |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with date in user form | New Users to Excel | |||
| Allow user to fill in on-line form without changing formatting | Excel Worksheet Functions | |||
| Formatting the linked cell when using a List Box User Form | Excel Programming | |||
| Text Box on User Form Set Focus Issue | Excel Programming | |||
| User Form textbox formatting | Excel Programming | |||
Threaded Mode
