LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
JTB JTB is offline
external usenet poster
 
Posts: 2
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I check if a cell is formatted as a date in Excel VB? Alex@LM Excel Worksheet Functions 2 September 10th 09 12:50 AM
Date columns are formatted incorrectly on export to excel Mona Excel Discussion (Misc queries) 1 June 6th 07 03:53 AM
ControlSource and Localization Issue?? (run-time error '380' Could not set the ControlSource property) TCook Excel Programming 1 March 4th 07 08:12 AM
Excel shouldn't bitch about a "date format" when formatted as txt Ibbits Excel Discussion (Misc queries) 5 July 18th 05 05:05 PM
how to get the number of days between two date formatted fields in vba for excel? Daniel Excel Worksheet Functions 1 July 12th 05 01:53 AM


All times are GMT +1. The time now is 06:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"