XL2000: Edit Box Does Not Appear in Toolbox (213775)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q213775

SYMPTOMS

When you are working with a UserForm in a Visual Basic for Applications project, the Toolbox that contains all the available controls for the UserForm does not contain an edit box control.

CAUSE

The edit box control, which is available on the Forms toolbar in Microsoft Excel 5.0 and 7.0 dialog sheets, is replaced by the text box control in Microsoft Excel 97 and 2000.

MORE INFORMATION

In addition to the text box control, you can add a ref edit control to a UserForm. The ref edit control is similar in function to an edit box control with an InputType property that is set to xlReference. You can use the ref edit control to select a cell range. The range reference is automatically entered in the ref edit control.

NOTE: By default, the ref edit control is not available in the UserForm Toolbox. To make the ref edit control available in the Toolbox, follow these steps:
  1. In the Visual Basic Editor, insert a UserForm into a project.
  2. On the Tools menu, click Additional Controls.
  3. In the Additional Controls dialog box, click to select the RefEdit.Ctrl check box, and then click OK.
The ref edit control is displayed in the Toolbox.

REFERENCES

For more information about using a text box control in a UserForm, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type textbox control in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

213776 XL2000: How to Use the RefEdit Control with a UserForm

Modification Type:MinorLast Reviewed:10/11/2006
Keywords:kbdtacode kbprb kbui KB213775
©2004 Microsoft Corporation. All rights reserved.