Show search results in Userform

I made a userform where i like to search in a drop down list for a "KKS" and when selected a "KKS" the info "KKS benaming", "Gecre?erd door" and "Omschrijving" is given.

I tried to make a code to only show non empty cells in de KKS droplist. This isn't working. I don't know why?

I tried this but somehow the is an error in Me("Textbox" & p)...... line?

Please Login or Register  to view this content.

This is enough (first empty the rowsource property of your combobox)

Please Login or Register  to view this content.

Thanks all!

Someone knows how te do this with a Textbox?

Please Login or Register  to view this content.