Populating a userform listbox from a database

All,

I am developing a spreadsheet (using macro code found in this forum) to allow users to search for people who speak a specific language. The spreadsheet is attached.

I have created a userform on the "Database" sheet that has a listbox at the bottom that populates with records when I search for someone using the 'Name' box.

The problem that I am having is that when I enter "Person" and get the 30-odd records appear in the listbox, I click on say Person 5 BUT the userform fields do not update themselves fully with the correct information.

I found the following thread

http://www.excelforum.com/excel-prog...d-replace.html

that has a recommended solution, yet because my userform is a combination of textboxes and comboboxes and not simply textboxes, it doesn't seem to work. The macro name is ListBox1_Click()

Does anyone have a solution to my problem?

I have other problems, but will post these as separate threads.

Thanks

James

When you are setting range references you are not fully qualifiying them

You need to include the sheet object in both places when refering to the range.

Please Login or Register  to view this content.

As a start yes.

Your filtering is not correct in the FindAll routine

Please Login or Register  to view this content.

I have added another listbox to the form. This is used to store the row number for each item found.
You can then use this row number to populate the form when a person is selected in the list.

yes, just set the visible property to False.