List Box to Populate Results

**Trueman_86** · 06-30-2010, 04:34 AM

Query.xls

Hi all.

Please see attached. I would like to use a List Box (Or other if you think apporpriate) which when pressed looks up information on another tab to populate boxes alongside it.

For Example: You click 'Student 1' using the List Box and it populates the boxes to the right with certain information (more clearly shown in Excel Attachment).

I would like the list box to include the full Name and also DOB.

I have tried various options (knowledge of excel is limited) - such as VLOOKUP, OFFSET, and so on.

Please Help

**martindwilson** · 06-30-2010, 05:49 AM

looks high and low but see's no attachment lol

**yariv** · 06-30-2010, 05:53 AM

Hi,
Check this out I think that should work for you (attached)
Yariv

**Trueman_86** · 06-30-2010, 06:06 AM

Firstly a huge thank you Yariv!

What course do I need to attend to be able to do that kind of stuff?

Secondly, Is there a way in which to populate the list box with all of the following:

First Name, Surname, DOB? So that when choosing, I am guaranteed that it is the correct person?

Thanks again. Brilliant

**yariv** · 06-30-2010, 07:33 AM

Thank you Trueman_86,
In order to do that you will need to use an Active X control List Box and set the properties to more than 1 column.
You can find many examples online if you need.
p.s. there are many Excel courses but the best way is to try and check for solutions on line.

Yariv