Help required in user form

Hi,

I have a excel workbook containing three sheets. The details of which are as follows.
Main --> Contains the button to open the user form.

Sheet1 --> Contains the Module Name in row 1 and their corresponding responsibilities in subsequent columns.

Sheet2--> Contains the User Name in first row of the column and the corresponding responsibilities assigned to the user.

The issue is that I have created a user form in which as soon as I enter the User Name in the text box the system should find all the responsibilities assigned to the user and list them in the combo box next to it and When I select a particular responsibility pertaining to the user the system should check the corresponding Module from the Sheet1 and show it in the next text box.

I am pretty new to Excel programming , I would really be obliged if someone can help me with this.

I am attaching the .xls file for your reference.

With regards

Your vocabulary is confusing, but maybe this will help

Please Login or Register  to view this content.

I did not see your example originally,
This code will add items to your listbox

Please Login or Register  to view this content.

Originally Posted by umayank

sorry thats not what is required. I will rephrase it what I want..

In the user form there is a text box where I enter the username. The user name and corresponding responsibilities are stored in Sheet2 so as soon as I enter the username in the user form the corresponding responsibilities should be displayed in the combo box next to it( a username will have many resposibilities). From the list of responsibilities when I choose one of the responsibilities then its corresponding Module (which is stored in sheet1) shouold be displayed in the text box2.

Thanks

Confusion with the word module

There's a form that displays data from a sheet and you can filter the data by using comboboxes on the form

http://www.sendspace.com/file/fesfxr