Results 1 to 5 of 5

VBA used to allow multiple drop down selections in one cell causing date format to change.

Threaded View

  1. #1
    Registered User
    Join Date
    01-29-2023
    Location
    UK
    MS-Off Ver
    unknown
    Posts
    5

    VBA used to allow multiple drop down selections in one cell causing date format to change.

    Hello,

    I'm very new to excel spreadsheets and so far have got on quite well.

    I'm creating a sheet to be able to make multiple selections in one call using validation tool and also a code I had found that is required to do so.

    The code works great except for some reason when running any date I input in UK auto changes to US format.

    It is linked to the code as the moment I delete it, the issue resolves.

    Hoping someone can check the code and see what might be the cause and if possible to correct without affecting the codes ability to do what is needed.


    HTML Code: 


    Thanks.
    Last edited by Telemusik; 01-29-2023 at 03:14 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Fill date based on multiple drop down selections
    By KOTZBROCKEN in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-14-2021, 02:11 AM
  2. [SOLVED] Better format for conditional formatting for multiple selections in a cell?
    By JulianS96 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-07-2020, 11:02 AM
  3. Replies: 10
    Last Post: 08-12-2017, 09:57 AM
  4. Making a cell wording change dependant on multiple selections
    By Mr.Shanahan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2017, 05:16 PM
  5. Replies: 0
    Last Post: 02-14-2013, 01:05 PM
  6. [SOLVED] Update respective cell values in the table based on Multiple Drop Down list selections.
    By nileshpatil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2012, 09:30 AM
  7. [SOLVED] Update respective cell value based on Multiple Drop Down list selections
    By nileshpatil in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-16-2012, 08:43 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1