Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
date and VB
If I have a date configured out of text and put this value into a
button.caption the date is given correctly. But if i take this value and put it from the button on the form to excel sheet a proble occurs: 20th of august 2005 on button = 20-8-05 and in excell as well 10th of august on button = 10=8-05 and in excell sheet it is 8-10-05 with cells dd-mm-jj. Anyone has a solution /? C |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
date and VB
Stephen Bullen wrote a whole chapter on international issues in the book
"Excel 2002 VBA" he co-authored (Wrox). There he discusses how problems like yours come about because VBA "speaks American" even in non-American locales. His advice is not to send Excel literal strings from VBA but to first convert them to the date type you want. For a date one way would be: Range("A1").Value = DateSerial(2005, 8, 10) so you'd have to parse the text on the button into its three date components. -- Jim "Christophero" wrote in message ... | If I have a date configured out of text and put this value into a | button.caption the date is given correctly. But if i take this value and put | it from the button on the form to excel sheet a proble occurs: | | 20th of august 2005 on button = 20-8-05 and in excell as well | 10th of august on button = 10=8-05 and in excell sheet it is 8-10-05 with | cells dd-mm-jj. | | Anyone has a solution /? | C |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate including a date so that the date appears as a date | Excel Worksheet Functions | |||
date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |