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...