The information in this article applies to:
SYMPTOMSIf you try to drag a control from a UserForm onto a Microsoft Excel 97 worksheet, the cursor will turn into a "No Cursor" (a circle with a diagonal line through it), and you cannot drop the control onto the worksheet. Also, if you cut or copy a control from a UserForm, you cannot paste the control into a worksheet. CAUSEMoving or copying a control from a UserForm to a worksheet is not supported in Microsoft Excel 97. RESOLUTIONIf you want to place a UserForm control on a worksheet, insert a new control from the Control Toolbox toolbar. To insert a control on a worksheet, do the following:
STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. MORE INFORMATION
In Microsoft Excel 97 you can add ActiveX controls to your worksheets for
making custom applications. The ActiveX controls that you can add to your
worksheet are on the Control Toolbox toolbar. To display the Control
Toolbox toolbar, point to Toolbars on the View menu, and then click Control
Toolbox.
REFERENCESFor more information about ActiveX Controls, click the Index tab in Microsoft Excel Visual Basic Help, type the following text Toolboxand then double-click the selected text to go to the "Toolbox" topic. Additional query words: XL97 vbe editor user form dialog box
Keywords : xlui xlvbainfo |
Last Reviewed: November 4, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |