VBA code to select data from table into combobox
 

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.

VBA code to select data from table into combobox
 

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.