combobox duplication
 

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

"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy

Pat wrote in message
...
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