| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why does ControlSource in Excel return a US-formatted date
When I link a TextBox to a spreadsheet cell that contains a date by
specifying a ControlSource for it, the TextBox displays a US-formatted date. What's going on? I've checked every locale and international setting that I can find, and they are all European. Is the US date actually hard-coded into the TextBox control? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why does ControlSource in Excel return a US-formatted date
JTB
You will find most controls and associated controls in VBA are US-Centric. You will normally have to format specifically for EU style -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk UK Excel User Conference In Cambridge November 28th - December 1st 2007 Register Now @ http://www.exceluserconference.com/UKEUC.html "JTB" wrote in message ... When I link a TextBox to a spreadsheet cell that contains a date by specifying a ControlSource for it, the TextBox displays a US-formatted date. What's going on? I've checked every locale and international setting that I can find, and they are all European. Is the US date actually hard-coded into the TextBox control? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I check if a cell is formatted as a date in Excel VB? | Excel Worksheet Functions | |||
| Date columns are formatted incorrectly on export to excel | Excel Discussion (Misc queries) | |||
| ControlSource and Localization Issue?? (run-time error '380' Could not set the ControlSource property) | Excel Programming | |||
| Excel shouldn't bitch about a "date format" when formatted as txt | Excel Discussion (Misc queries) | |||
| how to get the number of days between two date formatted fields in vba for excel? | Excel Worksheet Functions | |||
Linear Mode
