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.