Excel Userform combobox linking

[Akbarov]

Hey dear community,

I have userform where user enter data to textbox and results are showing in userform labels, but entered name can have several match data. So instead of textbox i want to use combobox
User type few letter and matching names shows on cells Al2, Al3 , AL4 , AL5 .... AL12 and when user choose one of them on combobox, that name enters to z2 cell and labels showing result based on z2 data on labels ( label3 to label 23 )

 

[jolivanes]

Are all the references changed properly?
It works like a charm om a little example I made.

BTW, you don't "enter data to the listbox". You type into a textbox (TextBox1) in the code.

 

[Akbarov]

i'v deleted textbox will try again

 

[Akbarov]

Sorry it works but it shows other column results too

 

[jolivanes]

You must have changed something to the wrong values.
Go over it again.