Change date in userform listbox to dd/mm/yyyy format

[cath1509]

Hi all,

I have a userform in which a listbox resides. The user has to select an item on the listbox, fill in the userform and then the data entered will be populated against the item selected. The columns that are pulled into my listbox are columns 2,4,7,8. They are all text apart from column 8, which is the date. In the spreadsheet that the listbox pulls from, the date is in UK format. However it displays as US format inside the listbox which is very confusing for the user as we live in the UK and are used to dd/mm/yyyy! I need to be able to change it to the UK format!

The code to the userform is below (the listbox population bit is at the end):

Please Login or Register  to view this content.

I have tried adding this in as the end of the code after the listbox is populated, but it is not working...any other ideas would be greatly appreciated!

Please Login or Register  to view this content.

Thanks!

[Izandol]

You may use:

Please Login or Register  to view this content.

or simply:

Please Login or Register  to view this content.

if the cells are formatted as you wish. However the Text property can make your code slow down if you have many records.

[cath1509]

Hi Izandol,

Used the first one you suggested, worked like a charm!

Thanks so much!!

[Norie]

If you use the 2nd suggestion you'll get the value as it's formatted in the sheet.