Hi Corey

Not sure if this will help you could try putting the value in to the
listbox as .text rather than .value so that the listbox shows the date
as text rather than a date which would result in you having the
correct format that you could then change back into a date if you need
to. this may be a pain in the ass depending on how you are putting
the values into the listboxes but it may help

Steve