VB Excel User forms

[pretty gal]

Private Sub txtIssuedDate_AfterUpdate()
    txtIssuedDate = Format(txtIssuedDate, "MMM/DD/YYYY")
End Sub

How can i format date ?
When i type 01/01/2005, txtIssuedDate changed to Oct/09/4670

How come i am not getting Jan/01/2005?

Thank you in advance

Pretty

[Hack]

Excel VBA question moved to Office Development

[RobDog888]

Private Sub txtIssuedDate_AfterUpdate()
    txtIssuedDate = Format(txtIssuedDate, "MM/DD/YYYY")
End Sub

The "MMM" specifies the short version of the month name. Use just "MM" to get the 2 digit month index number.

[zaza]

Assuming you did want the short month name, I don't know. I've tried it in Excel and it works in both cells and in a textbox on a Userform.
Can you be more specific?

zaza

[New2vba]

I had similar problem and this fixed it - entries into this text box (which are on a userform) act just like cells in excel with date format applied, i.e. entering 01-01 should give you Jan/01/06.

Private Sub txtDate_AfterUpdate()
     
'DATE ENTRY FORMAT VALIDATION
     
    If IsDate(txtDate.Value) Then
    txtDate.Value = Format(CDate(txtDate.Text), "mmm/dd/yy")
    Else
    MsgBox "Entry must be in date format, MM-DD-YY" & vbCr & _
    "Entry will revert to current date.", vbExclamation + vbOKOnly, "Incorrect Date Format!"
    txtDate.Value = Format(CDate(Date), "mmm/dd/yy")
    End If
    
End Sub

This may be slightly different in that I load the text box with the current date when my userform is initialised. This code also reverts the value to the current date if the user does not enter a valid format.

It may not be the best way to do it (I am a novice at best), but it works for me. Hope it helps.

[pretty gal]

Private Sub txtIssuedDate_AfterUpdate()
txtIssuedDate = Format(txtIssuedDate, "MMM/DD/YYYY")
End Sub

MM or MMM both do samething..

Excel worksheet - i have no problem formatting the field..
Only with userform, textbox "txtIssuedDate" does not working the way i wanted with after_update method.
when users type 01/01/2005........i want the txtbox to change either jan/01/2005 or 01/01/2005 but its not working that way.

i am getting wrong dates in both format.
hmmm
thank you in advance
any help will be appreciated......

pretty
recent grad

[pretty gal]

New2vba
I am going to try your coding thanks

[pretty gal]

it worked perfectly.........

thank you so muchhhhhhhhhhhhhhhhhh