thanks . I appreciate for your help, but unfortunately this doesn't what I want . the orginal code each combobox depends on each other of them . if you make a selection in one box (say ComboBox1), can be more than one option (e.g. ComboBox2) and I want filling all of the comboboxes at once instead of depend on just four comboboxes and no need the QTY by combobox . I don't want select just populate into textbox . your way I have to search the item for all combobxes , but the orginal code is flexable just select first combobox and will populate the others comboboxes when select next combobox for each row on userform where contains four comboboxes .
I hope to understand what I want . sorry this is my first thread if it's not clear !!