I have a Combobox (Name: StartDate) containing a list of date values to select from.
The ListFillRange sources a list of dates including today's date (Now) with approximately 80 retrospective date values as well as a number of future dates.
When the user clicks on the StartDate combobox I would like the date value to default to "today's" date but still be able to select an alternative retrospective or prospective date from the available list.
See attached sheet for reference.
Can someone please assist with the appropriate VBA code?
Thanks
Bookmarks