Instead of creating your own form, you might be able to use John
Walkenbach's Enhanced Data Form.

http://j-walk.com/ss/dataform/index.htm

It allows comboboxes, and unlimited fields.

harrys wrote:
I'm generally an Access person, but have an excel task to
complete. I need to create a form within excel 97 that
can populate fields with drop down lists. I've written a
macro to auto-start the data-form that comes with excel 97
but am not sure if it is possible to add drop downs to
it. I wonder if I will need to create a completely new
form. Thanks in advance for any input/ideas/links ! My
deadline is nearing.

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