Is Possible to have a Dependent ActiveX ComboBox on another ActiveX ComboBox?

[AssGuardian]

Hello, Pros,

I need some help regarding the Dependenct Combobox on another Combobox.
I've attached the Link of file below which explains everything.
please help !!!


Link : Book1.xlsm

 

[6StringJazzer]

First I added a LinkedCell (H9) to your first combobox so that a formula can be created based on what is selected in that combobox.

Then I created a formula to give the list for the second combobox. You can see this formula in K9, but that is just to illustrate how it works. You can delete K9.

I created a name for this formula NameList and assigned it to the ListFillRange property of the second combobox.

populate the value in A1 Cell

No idea what you mean by that.

I didn't want to edit your original file so here is a link to my version.

Dropbox

www.dropbox.com

 

[AssGuardian]

@6StringJazzer Thanks for the Response,
I was asking that the selection from 2nd combobox would be linked to cell A1 but still this helped me a lot. Thanks again

 

[6StringJazzer]

You just need to set the LinkedCell property.

 

[AssGuardian]

yes, and once again Thanks