Issues outputting date from listbox

Hi,

I have a strange issue when trying to get selected results out of a listbox.

Listbox.jpg

this is how the listbox looks

I run this code to transfer the selected items to a worksheet.

Please Login or Register  to view this content.

but when I go and see the output I get a mixture of US and UK dates. In fact, when I look at the formatting for the top two dates, they are formatted as general.

results.jpg

I repeated the task but added dates, 23/01/2023, 31/01/2023 and 06/02/2023. The first two dates were fine, but the third date switched to US.

It looks like if it's impossible to display a US date, e.g. 31/01/2023 it's ok. Where a date can be switched, e.g. 02/01/2023 or 02/06/2023 (can be switched to 01/02/2023 and 06/02/2023) is changes to US

I have tried forcing the listbox to show UK format:

Please Login or Register  to view this content.

but this doesn't work

Any ideas on how this can be resolved?

TIA

Cheese, that worked like a charm. Thank you for the quick reply.