Do you really need 2000 combo boxes, or could you use DataValidation
instead? It would create a dropdown list in the cell.

There are instructions in Excel's help, and he

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

Alexander Jakopin wrote:
i want to write a macro which copies a dropdownfield 2000 times and
changes the cell reference according to the dropdown's new position.
the problem is that i can change the position of the new dropdown field
but not the cell reference, or the cell reference but not the position,
not both the same time.


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