Share via

EXCEL USERFORM DATE FORMAT PROBLEM

Vikramsing Kachhava 1 Reputation point
Sep 9, 2022, 1:25 PM

Im still new with the excel VBA. When I key in the date in the VBA form using this format (dd/mm/yyyy), it will interpret automatically as mm/dd/yyyy in the worksheet. My computer system settings for the date format is in dd/mm/yyyy and the excel date format is dd/mm/yyyy (I tried to put it as General and custom, both didnt work). Is there any solution for this? The VBA coding might help I guess.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,848 questions
Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,502 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Daniel Colardelle 1 Reputation point
    Sep 13, 2022, 1:26 PM

    Try :

    Dim Dat
    Dat = Split(Me.TextBox1.Value, "/")
    Range("A1") = DateSerial(Dat(2), Dat(1), Dat(0))

    Daniel

    0 comments
  2. Aurélien ATIBARD 1 Reputation point
    Sep 15, 2022, 12:17 PM

    Hi,

    You can force the date format as follow :
    Format(Range(yourRange), "dd/mm/yyyy")

    You can also check the "regional format" of your computer in your "Region" settings

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.