View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Deke Deke is offline
external usenet poster
 
Posts: 22
Default Date Format in a Userform Listbox

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