Gerry

You can do this with ActiveX controls and event macros. I posted some
screen shots here

http://www.dicks-blog.com/archives/2...box-filtering/

Let me know if that's not what you're looking for.


--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Gerry Bennett wrote:
I have data stored in a table, Surname, firstname, date of birth.
What I want to do is select the surname in the combobox I have done
this part. I then want to select the firstname from the associated
data in the table, ie three people sharing the same surname but
different first names, so that only those three names show not all
the names I have in the list. this should then be down to one name
and the date of birth then populates the third box. Can anyone help
me out with this.