XL2000: You Cannot Copy a Control from a User Form and Paste It to a Worksheet (215164)
The information in this article applies to:
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.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. REFERENCESFor more information about creating a user form, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type creating a user form in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type: | Major | Last Reviewed: | 9/27/2003 |
---|
Keywords: | kbbug kbpending KB215164 |
---|
|