Hi everyone,

its my first time in ExcelForum, and i landed here, because im working with excel, making a vb user-form, and got stuck in a problem.
I hope someone can help me out in this.
so, lets start by the beginning, and im going to explain what is my source, what is my problem, what i have till the moment and what i need.
So i have 1 worksheet where i have several rows. 1 row for users, 1 for usercode, 1 row for tools, 1 row for group.
i made 1 user form where in 1 combobox it searches for the users, and 3 textboxes were it displays the other data corresponding to that user.
Till here the program is working perfectly. Now i have another worksheet, wich i can put in the first one, to be more simple, where i have Tools, group, phone contact, email contact, area responsible and order. To some tools it corresponds more the 1 area responsible wich have an order number. I need to make an aplication in wich, i search for the tool in 1 combobox and once it finds the tool, it displays the area responsibles, if more then 1, and their corresponding order. Also at the same time, it has to let me select wich area responsible ( i think its a listbox ) and display the rest of the data in corresponding text box.
Can someone help me with this?
Thank you in advance