Results 1 to 8 of 8

Thread: VB Excel User forms

Threaded View

  1. Jan 12th, 2006, 02:27 PM #1
    pretty gal
    pretty gal is offline

    Thread Starter
    Member
    Join Date
    Jan 2006
    Location
    Toronto, Canada
    Posts
    41

    VB Excel User forms

    VB Code:
    1. Private Sub txtIssuedDate_AfterUpdate()

    2.     txtIssuedDate = Format(txtIssuedDate, "MMM/DD/YYYY")

    3. 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
    Last edited by RobDog888; Jan 12th, 2006 at 02:55 PM. Reason: Added [vbcode] tags
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width