Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Edinburgh, Midlothian, Scotland
    Posts
    492
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA DAte formats (Xl 2003)

    My latest query.

    I've designed a user form, and I've Initialized it to full combo boxes etc. 1 item pre-fills to DATE.

    This shows in the form as a US date, but when the data is transferred to the spreadsheet it shows the correct date in the correct format..

    I've searched the archives to discover a few threads explaining that VBA speaks American, but I can't see if there is a solution to get my form showing its date in a UK format.

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: VBA DAte formats (Xl 2003)

    Strange, I'm using Excel 2002 on a Dutch language system with dd-mm-yyyy date format, and dates are displayed that way on userforms too. Perhaps someone with UK English settings can shed light on this.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA DAte formats (Xl 2003)


  4. #4
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Edinburgh, Midlothian, Scotland
    Posts
    492
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA DAte formats (Xl 2003)

    Not sure.

    I don't fully understand it. I'll need to play with it later

Posting Permissions

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