Hi,
I have a multi-column listbox in an excel userform that is populated from a recordset (using .getrows). The recordset is from an Access database.
One of the columns in the listbox is a date field and although the date format in the Access database is DD/MM/YY (and I have verified that all the dates are in fact stored in this manner), the date is shown as MM/DD/YY in the Excel listbox. i.e. the DD and MM are swopped around.
I have also made sure that the date format in local and regional settings for my pc is set to DD/MM/YY.
I guess that Excel's listbox automatically shows dates in MM/DD/YY format
Any ideas on how to make sure that the date format in the Excel listbox is shown as DD/MM/YY ??
Thanks for any help!
I have a multi-column listbox in an excel userform that is populated from a recordset (using .getrows). The recordset is from an Access database.
One of the columns in the listbox is a date field and although the date format in the Access database is DD/MM/YY (and I have verified that all the dates are in fact stored in this manner), the date is shown as MM/DD/YY in the Excel listbox. i.e. the DD and MM are swopped around.
I have also made sure that the date format in local and regional settings for my pc is set to DD/MM/YY.
I guess that Excel's listbox automatically shows dates in MM/DD/YY format
Any ideas on how to make sure that the date format in the Excel listbox is shown as DD/MM/YY ??
Thanks for any help!