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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date formatting issue in user form
Hi Jennifer
You may need some additional error checking etc, but this may help Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) If Len(TextBox1) < 6 Then MsgBox "6 numbers required in ''mmddyy'' format please" Exit Sub End If TextBox1 = Left(TextBox1, 2) & "-" & Mid(TextBox1, 3, 2) & "-" & Right(TextBox1, 2) End Sub -- ----- XL2003 Regards William "Jennifer" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date formatting issue in user form
Hi Jennifer,
try this. Private Sub txtDate_Exit(ByVal cancel As MSForms.ReturnBoolean) txtDate.Value = Format( date("20" & RIGHT(Me.txtDate.Value,2),LEFT(Me.txtDate.Value,2) ,MID(Me.txtDate.Value,3,2)), "dd/mmm/yy") End Sub be careful on reformatting the textbox when you re-enter it. HTH Fadi www.chalouhis.com/XLBLOG |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date formatting issue in user form
Take a look at http://www.xldynamic.com/source/xld.QDEDownload.html
-- HTH RP (remove nothere from the email address if mailing direct) "Jennifer" wrote in message ... 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 |
Reply |
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 |