combobox duplication

  • Thread starter Thread starter Pat
  • Start date Start date
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
 
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.
 
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
 
Back
Top