Windows 10: 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?



:)

 

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.

 

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.