|I assume by "mass produce this" you mean the creation of the combobox and linking to the cell, correct?|
I don't do much with comboboxes, so I don't know if this will work, but have you tried recording a macro as you create the combobox and link it to cell, then placing a loop around the code that is produced to repeat the actions multiple times?
Try recording a macro and then post the code back here so I can see what is produced.
Please click on the following line and read the insructions found via that link before posting the code. Thanks!
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.