Take a look at Debra Dalgleish's site:

http://www.contextures.com/xlDataVal01.html

In article ,
"Katherine" wrote:

I am trying to create my own drop down list in a data base
where the user can pick from a list of information click
on what applies and it will fill the blank - I have my
excel bible handy here but am finding it hard to follow
HELP? Is there someone out there who can walk me through
this? Thank you Katherine
.