combobox duplication

P

Pat

I have set up a combobox where the linked cell is underneath the control.
The control ListFillRange and other properties are set. Can some let me know
how I can copy the control to a series of cells beneath. In other words fill
down and have each control linked to the corresponding cell with the
ListFillRange and other properties also set.

Thank you if you can enlighten me.

Pat
 
T

Tom Ogilvy

If you mean manually, you can't. You would have to edit each. with code,
you would have to set these properties for each copy.
 
P

Pat

Does this mean it would be a mammoth task given I have over 500 cells in a
single column where each cell would have a combobox created?

If code will help to do this is there an example of this on the web where I
can download?

Pat
 
Top