Greg,

I assume that you are referring to the Listbox contents. Make sure the
worksheet cells are formatted in the date format of choice, and use

I have tried it and I don't get the problem. The dates load as format
dd/mm/yyyy for me.
--

HTH

RP
(remove nothere from the email address if mailing direct)


"Greg B..." wrote in message
...
Private Sub UserForm_Initialize()
Do Until Sheet1.Range("a2").Offset(counter).Value Now + 14
counter = counter + 1
Loop
UserForm1.ListBox1.ColumnCount = 3
UserForm1.ListBox1.List() = Sheet1.Range(Cells(2, 1), Cells(counter,
3)).Value
End Sub


Thank you Bob

Greg