Hi
I am using a combobox on my userform to select a date
The combobox currently has 3 options for dates:
18/11/2021
19/11/2021
20/11/2021
The combobox look at a sheet which has the 3 dates [cells are formatted as date]
=today()-2
=today()-1
=today()
The issue i have is the dates are displayed correctly in the userform combobox but when i select a date such as 20/11/2021 it is displayed as 44520 in the combobox but does transfer onto a sheet as a date
How do i fix this so the actual date is displayed in the combobox?
Other option: Is there a vba code for displaying the dates in the userform combobox which uses vba code therefore no need to look at another sheet for the dates
Thanks
I am using a combobox on my userform to select a date
The combobox currently has 3 options for dates:
18/11/2021
19/11/2021
20/11/2021
The combobox look at a sheet which has the 3 dates [cells are formatted as date]
=today()-2
=today()-1
=today()
The issue i have is the dates are displayed correctly in the userform combobox but when i select a date such as 20/11/2021 it is displayed as 44520 in the combobox but does transfer onto a sheet as a date
How do i fix this so the actual date is displayed in the combobox?
Other option: Is there a vba code for displaying the dates in the userform combobox which uses vba code therefore no need to look at another sheet for the dates
Thanks