If the dropdowns are data validation lists, you can follow the
instructions he

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

If the drop downs are combo boxes from the forms toolbar or the control
toolbox, you can enter an Input Range or ListFill range

Snakeoids wrote:
Greetings,
I have an Excel document that has a couple of drop down list controls, but
no values in them. How do I create values for these drop down lists? Thank
you.
Rod


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html