hi
if you are using data validation...
see this site. It explains how to do that.
http://www.contextures.com/xlDataVal01.html#DataVal01

real good site too. lot of good tip concerning a great number of thing.
after reading up on validation. click home then tips.

Regards
FSt1

"Joanne" wrote:

Using MSOffice2003
From reading around the groups and following helpful links I learned how
to create a list on sheet1 and name the range and use the offset command
to set up data validation as a means for filling drop boxes on my main
worksheet.
Problem is, I don't know how to get the actual drop box into the cells
in the necessary column on my worksheet. Duh, it can't be that hard but
I have no clue how to proceed.
All help gratefully accepted by this newbie.
Thanks
Joanne