Can't do... You need to get a link to the controls and make copies of them.
Are the controls from the forms toolbar or from the control toolbox. What
kind of controls are they...
--
HTH...

Jim Thomlinson


"Robert Davidson" wrote:

Manually I can switch to design mode, copy a range full of form controls and
paste it to another area. If I do not switch to design mode, it does not copy
the controls.

I would like to do this programmatically. Is there any way to enter design
mode through VBA? Record macro doesn't help, and searching XL VBA help for
design mode doesn't show anything I recognize as promising.

Many thanks,

Robert Davidson