Userform search engine depended combobox

Hi Guys,

Im working on a excel file for more than a week now and I still can't find a solution for my problem.
I've got a sheet named ''Data" with the following information: column A: object, Column B: code, Column C:F product information.

I want to create an userform with a search engine:
1: An user can search on the code or object name (ComboBox1_choice);
2: After that ComboBox_depended will show: the object names or codes (some users only know the codes other users only know the object), the user can typ in the right code or object;
3: ListBox_results will show the object name, code, objectinformation (C:F)
4: a button to send the object name to sheet 2 cell a2. (the selected item (only the object name) in the listbox will be send to sheet a2)

is this possible??

I've made an excel helpfile. The userform and combobox1_choice has been made already.

This should do the trick

Beautiful! It works perfect!!! Thank you for your work

One last question: is it possible that the first item that appears in the listbox will be automatically selected?

Glad if i can help

And sure that is possible just do this.

in the Inititialize part add the green code part

Please Login or Register  to view this content.

in the choice change part add the same for the dependent box

Please Login or Register  to view this content.

Hi,

It seems like it doesn't do the trick. The first option in the listbox_results isn't selected. Should the green part be: me.ListBox_results.ListIndex = 0 ?

ah you want the result in the listbox to be selected :D
I thought you wanted that the firest result in each combobox gets selected :D

in this case just add this also

Please Login or Register  to view this content.

many many thanks it works