VB Excel User forms

VB Code:

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

Excel VBA question moved to Office Development

VB Code:

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.

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

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.

VB Code:

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.

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:)

New2vba
I am going to try your coding thanks

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

thank you so muchhhhhhhhhhhhhhhhhh :) ;) :cool: