How about an alternative?

Instead of using a dropdown from the Forms toolbar or a combobox from the
Control toolbox toolbar, you may be able to use data|validation.

Debra Dalgleish has lots of info:
http://contextures.com/xlDataVal01.html

Browniris wrote:

I am making a data-entry spreadsheet. I have a drop down menu for each
column, and I want to copy that drop down menu and paste it in each cell for
that column. When I have tried to follow instructions on excel (copy, paste
special, check validation), the top item in the menu is erased. It looks like
the range is changing in each cell (i.e. =F1:F6 in F16 goes to =F2:F7 in F17,
then =F3:F8 in F18). How can I copy my drop down menu and keep it the same
for each cell?

Thanks for your help!

--

Dave Peterson