Hello,
I am working in excel 2010 and I would like to create a combobox (list) using the developper ribbon that leverages a list of dates from another tab. I created the combo box and used a named range as the source of dates but I cannot see a way to select unique values only. Is there a way of doing this with the properties window?
PS: I would not like to create a dropwon list using the data validation option in the data tab.
Thanks for your ideas!
C111
I am working in excel 2010 and I would like to create a combobox (list) using the developper ribbon that leverages a list of dates from another tab. I created the combo box and used a named range as the source of dates but I cannot see a way to select unique values only. Is there a way of doing this with the properties window?
PS: I would not like to create a dropwon list using the data validation option in the data tab.
Thanks for your ideas!
C111
