Microsoft KB Archive/215164

= XL2000: You Cannot Copy a Control from a User Form and Paste It to a Worksheet =

Article ID: 215164

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q215164



SYMPTOMS
When you create a user form, and you insert a control on the user form, you can copy the control, but you cannot paste the control onto an Excel worksheet.

The control can be copied to another user form.

Captions and text inside a text box can be copied from the user form and pasted onto an Excel worksheet.

Text on an Excel worksheet can be copied and pasted onto a user form, but inserted objects copied from a worksheet, such as charts, cannot be pasted onto a user form.



CAUSE
This problem occurs because objects cannot be copied and then pasted between an Excel worksheet and the Visual Basic Editor.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

