Combobx in cascade

Hello EXCEL HELP
Hello every one
I ask again your help .. please dear members .. to finish the userform
Please how can we can do a search by title " combobox cascade "
I opening a file appears in ComboBox1 titles:
(NOM.PRENOM.AGE.ADRESSE.PROFESSION.MOBILE.EMAIL)
when I choose a title in combobox1 ..displays the column of this title in combobox2
Thank you very much in advance for the help
Cordially
MADA BLACK
COMBOBOX IN CASCADE.xlsm

and what is the column in your opinion ?


Kind regards
Leo

Hiii LeoTaxi
Thank you for help me
I could not express themselves correctly in English
for example I selected in combobox1 the title "NOM" appears in combobox2 "mada1 mada2 mada3 mada4 mada5 ........mada20"
I selected in combobox1 the title "ADRESS" appears in combobox2 "forum1 forum2 forum3 forum4 forum5 ........forum20"
I selected in combobox1 the title "EMAIL" appears in combobox2 "kk1 kk2 kk3 kk4 kk5 ........kk20"
And so on
Thank you master for help me
Sincerely
MADA BLACK
COMBOBOX IN CASCADE2.xlsm
1.jpg

Hiiii jaslake
Thank you for help and answer
yes but only :
NOM PRENOM AGE ADRESSE PROFESSION MOBILE Email
not xxx yyy zzz
Thank you
MADA BLACK

Originally Posted by jaslake

Hi MADA BLACK

I'll look at it...

Thank you master
t1.gif

See if this is how you wanted.

Please Login or Register  to view this content.

Hiii jindon
Thank you a lot for your help and for for your file
But I could not open the userform
Please look at these two pictures
Cordially
MADA
1.jpg
2.jpg

Are you on Mac?

MS-Off Ver : office2010

Try this instead.

Please Login or Register  to view this content.

Hiii jindon
Thank you very much
Now it works very well
That's exactly what I want to have
Thank you for you time sacred for help me
Cordially
MADA
t3.jpg