Date Format in a Userform Listbox

[Guest]

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.

 

[Guest]

Send it to the textbox as a string!

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.

 

[Alan]

Another way:

Private Sub ControlButton1_Change()
ControlButton1 = Format(ControlButton1, "dd/mm/yyyy")
End Sub

Regards,

Alan