Windows 10: VBA Forms textbox Date format locale problem

Discus and support VBA Forms textbox Date format locale problem in Microsoft Office and 365 to solve the problem; I'm using Excel VBA and an MSForms Textbox, bound to a worksheet cell containing a UK fiscal year date value of 6th April of some year I simply want... Discussion in 'Microsoft Office and 365' started by spilly, Jun 4, 2018.

  1. SPILLY
    spilly Win User

    VBA Forms textbox Date format locale problem


    I'm using Excel VBA and an MSForms Textbox, bound to a worksheet cell
    containing a UK fiscal year date value of 6th April of some year

    I simply want to display this date in a Forms Textbox, formatted in my locale style - dd/mm/yyyy OR dd mmm yyyy


    I can find no way to achieve this using a textbox control bound to the worksheet cell.
    (clarification added by OP....)
    The value always shows as "mm/dd/yyyy", even if the cell.text shows "6 Apr 2018"
    I've concluded that Binding to a cell always binds to the Value,
    and that dates are automatically and unconditionally formatted to the US locale


    Is that right? - You have to use an unbound ControlSource property ?
    or am I missing something obvious somewhere?



    :)
     
    spilly, Jun 4, 2018
    #1
  2. STEPHEN88
    stephen88 Win User

    Issue with using 'return key' in multiline textbox

    When I use multiline textbox, I got strange behavier, when I type the 'enter' key, instead of going to next line, the textbox expand to whole form area, still editable, then return key works, and I see two buttons showed below the form: Done and Cancel,
    push either one, textbox will back to original shape and size (and if type 'return' key, will expand again), seems 'return' key trigers the textbox internal event, pop up a default form, and whatever I set the acceptsReturn property 'true' or 'false' for textbox,
    it functions same.

    I use visual studio 8 as development tool, and windows mobile 6 standard emulator, can somebody give me a suggestion?

    Thanks.
     
    stephen88, Jun 4, 2018
    #2
  3. BILLION DEBBARMA
    Billion Debbarma Win User
    Windows 10 Date Format

    Hi Steve,

    Welcome to Microsoft Community and thank you for your interest in Windows 10.

    I understand that you are unable to locate the date format. I will definitely assist you.

    Please follow the below steps and check.


    • Click on the Date and time at the right bottom corner of your screen.

    • Click on Date and time settings and click on
      Change date and time format on right pane.
    Hope this helps. If you need further assistance with Windows, let us know and will be glad to help.
     
    Billion Debbarma, Jun 4, 2018
    #3
Thema:

VBA Forms textbox Date format locale problem

Loading...

  1. VBA Forms textbox Date format locale problem - Similar Threads - VBA Forms textbox

  2. Change Date format

    in Windows 10 Software and Apps
    Change Date format: How do I change date format from month day year to day month year? https://answers.microsoft.com/en-us/windows/forum/all/change-date-format/2e0b3c4b-67d5-42ed-9baf-da4c50520878

  3. Change Date format

    in Windows 10 Customization
    Change Date format: How do I change date format from month day year to day month year? https://answers.microsoft.com/en-us/windows/forum/all/change-date-format/2e0b3c4b-67d5-42ed-9baf-da4c50520878

  4. Time and Date Formatting

    in Windows 10 Customization
    Time and Date Formatting: Why can't I set my date to mm/dd/yyyy with my region set to Canada? The only way I could change it to what I wanted was to set my region to US. https://answers.microsoft.com/en-us/windows/forum/all/time-and-date-formatting/300d0a6d-a385-473a-a809-c5b9e2f6ae81

  5. Word 365 Title (same style as Msgbox for VBA) for Textbox? (w/o VBA)

    in Microsoft Office and 365
    Word 365 Title (same style as Msgbox for VBA) for Textbox? (w/o VBA): Word 365 How to have a Title (same style as Msgbox for VBA) for Textbox ? I need to display, but NOT print, Date formula in a Shape (hyperlinked to hidden text in main body of Word) with Title for this formula. If I can use VBA, I would use a Msgbox with Title. Word Textbox...

  6. date format

    in Windows 10 Customization
    date format: Why don't I have the month/day/year option in the date format? https://answers.microsoft.com/en-us/windows/forum/all/date-format/a1b705b5-e73b-4fdf-b91d-d08f0b59f8a0

  7. Date format

    in Windows 10 Customization
    Date format: Must include the date format dd/mm/yyyy in the Bangladesh regional setting https://answers.microsoft.com/en-us/windows/forum/all/date-format/4a639cd7-22d2-4de5-93e3-68066bc2d133

  8. "File Search Form" Error Different Textbox Control..?

    in Windows 10 Network and Sharing
    "File Search Form" Error Different Textbox Control..?: Usually, all forms in Windows use "Textbox Control". In Windows 10 this time, a different control was used for "file search". I am wondering if there is any special reason. This is because frequent errors occur. When I place the cursor on the "File Search" in a folder, the...

  9. Change date format

    in Windows 10 Customization
    Change date format: how do i change date format to mm/dd/yyy. currently it shows dd/mm/yyyy. https://answers.microsoft.com/en-us/windows/forum/windows_10-other_settings/change-date-format/369e7554-8e46-40f7-b522-b8c0a3b672ef

  10. Restrict User Locales for Date and Time Formats in Windows

    in Windows 10 Tutorials
    Restrict User Locales for Date and Time Formats in Windows: How to: Restrict User Locales for Date and Time Formats in Windows How to Restrict User Locales for Date and Time Formats in Windows The date and time formats for their account in Windows. If you like, you can restrict users to a specified list of user locales. Only...