Combo Box - Extract Dates
Posted by JAF on February 06, 2001 6:38 AM
I have a worksheet which has in column A a series of dates, some of which are unique, others of which are duplicated many times.
What I'd like to do is on another worksheet create a combobox on the sheet itself (not in a user form) which will be populated with a list of the dates from column A on the other sheet, but with each date appearing once only.
When the user selects a date from the list, I need that date to appear in Cell A2.
Any suggestions gratefully received.