Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Format in a Userform Listbox
Thanks for the reply. The date that is getting stored in the array, which is
then passed to the listbox, which is defined as a DATE type, so there is no convertion to a string happening. All that seems to be happening is it's getting changed from a UK date format, which is what I want, to a US date format. Hope this makes sense. -- Cheers... "Joel" wrote: Is the date getting converted from a "date to string" or "string to date". Excel time formats will always take any time (integer) because it is really just an integer from the year 1900. Then the time is displayed in different formats. If you are getting an errror then the time mustt of been converted tto a string. You then havve to convert the string back to a time using = datevalue(string) or in VBA datevalue(string) which will take any standard date format. "Deke" wrote: I am having a bit of a problem with the format of dates in a userform listbox. The dates going into the listbox is formatted as "dd/mm/yyyy" from an array, but when the userform is displayed the date changes format to "mm/dd/yyyy". When the date is them passed back to a variable and then used for a search it fails, obviously. Hope someone can help. -- Cheers... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Format in a Userform Listbox
Joel,
Came to the same conclusions just before your reply arrived, re-coding the script as we speak. That's it, work's perfectly, will now go and re-code the other parts that are doing the same thing. Thank's for pointing me in the right direction. -- Cheers... "Joel" wrote: Send it to the textbox as a string! "Deke" wrote: Thanks for the reply. The date that is getting stored in the array, which is then passed to the listbox, which is defined as a DATE type, so there is no convertion to a string happening. All that seems to be happening is it's getting changed from a UK date format, which is what I want, to a US date format. Hope this makes sense. -- Cheers... "Joel" wrote: Is the date getting converted from a "date to string" or "string to date". Excel time formats will always take any time (integer) because it is really just an integer from the year 1900. Then the time is displayed in different formats. If you are getting an errror then the time mustt of been converted tto a string. You then havve to convert the string back to a time using = datevalue(string) or in VBA datevalue(string) which will take any standard date format. "Deke" wrote: I am having a bit of a problem with the format of dates in a userform listbox. The dates going into the listbox is formatted as "dd/mm/yyyy" from an array, but when the userform is displayed the date changes format to "mm/dd/yyyy". When the date is them passed back to a variable and then used for a search it fails, obviously. Hope someone can help. -- Cheers... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Format for Userform TextBox | New Users to Excel | |||
Date Format in Userform | Excel Programming | |||
userform listbox cannot get listbox.value to transfer back to main sub | Excel Programming | |||
Date format in userform | Excel Programming | |||
Date format from UserForm | Excel Programming |