Activex ComboBox

[Portucale]

Hi,


I would like to offer the users a ComboBox which dynamically would get a list of my Define Names according to a cell reference.

Example:

List Name “Clubs” have
Club 1
Club 2
Club 3

Lis Name “Cities” have
City 1
City 2
City 3

In cell A1 (reference) I would have either “Clubs” or “Cities” do the ComboBox would show the values or the respective list name.

Any help and ALL help is very much appreciated.

 

[Abdul Matheen]

Hi Portucale,


please find the attached workbook with dynamic combo box list. it also update the list as soon as you enter new item into list.

Revert if you have any questions.

Regards
Abdul Matheen

 

[PeterB]

Another option might be: http://blog.contextures.com/archives/2013/09/26/conditional-drop-down-lists-in-excel/

 

[SirJB7]

Hi, Portucale!
Does this help? Not with combo box controls but with data validation chained lists:
http://chandoo.org/forum/threads/da...ically-shows-the-first-item-in-the-list.4201/
A similar approach can be implemented for combo box controls.
Regards!

 

[Portucale]

Thanks guys, great solutions and my issues are now resolved.

 

[SirJB7]

Hi, Portucale!
Glad you solved it. Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.
Regards!