Hello everybody.

This is my first post.
i found this forum very useful, and now i have problem which i want to solve, and i didnt find the solution into the forum.

So.. i have some kind of a form , which collecting data for me based on the options i choose from a dropdown menu
I what to use comboboxes, because of the autocomplete function which they have, which is very useful when using long defined list as I do.

I need to implement somehow this formula into the combobox ( " =INDIRECT(SUBSTITUTE(D12&D14," "," ")) ")

What i have is a Combobox1 which is with pre-defined listfill which directs to a "namelist" named Sport , which included sports (Football, Tennis, Basektball...etc)

and Im using this code in combobox1 to tell Combobox2 to look for a specific SUBname list

Private Sub Combobox1_Change()

Me.ComboBox2.Clear
Dim ListCell As Range
For Each ListCell In Range(Me.ComboBox1.List(Me.ComboBox1.ListIndex))
Me.ComboBox2.AddItem (ListCell.Value)
Next ListCell
End Sub
Combobox2 is my CLASS option , where if in Combobox1 I choose "Football", in combobox2 now i have (England, Germany..etc) which are all pre-defined name ranges


What Im trying to do i to tell my comboxbox3 to look for the combination for Combo1&2 and to give me the next optional list ...

Example (in COmbo1 if I have Football, then i Combo2 i choose "England" , Then in combobox3 I need to give me list with the England leagues to choose)

I hope i didnt sound very complicated.

I will appreciate every help
Thanks