Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Format in a Userform Listbox
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 in a Userform Listbox | Excel Programming | |||
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 |