Display Corresponding Value From Adjacent Column Based On Change of DropDown ComboBox

[mosesena]

I have two columns of data. The first contains 'names' and the second contains 'passwords'. The Userform is completed with information plus a combobox displaying 'names'. When the command button is clicked, the information is updated to a database and the 'name' selected in the combobox should display the matching 'password' on a message box.

The question is how do I code the combobox element of the userform to display on a message box, the 'password' matching the 'name' selected?

[alansidman]

Look at this attached file.

Open the VBE. Look at the Row Properties for the Combo Box and then look at the code for the text box.

[mosesena]

That is perfect but the display of 'password' should be in a message box and should happen when the user hits a command button.

[alansidman]

Ok. No worries. Look at the attached.

[mosesena]

That works....Thanks

[mosesena]

Ok. No worries. Look at the attached.

That certainly works...Thanks. The other part of it is ....if a user selects a name and password, that name and password should not be available for the next user. Question is how do I code it?

[alansidman]

Look at this link as it will do what you are wanting.

Remove selected options from dropdown list (http://www.excelforum.com/excel-general/970532-remove-selected-options-from-dropdown-list.html)

[bakerman]

Been playing around a little. Check if this suits your needs.
Several questions have to be answered yet but this gives you a general idea.