XL97: Edit Box Does Not Appear in Toolbox

ID: Q158639


The information in this article applies to:
  • Microsoft Excel 97 for Windows


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 TextBox control in Microsoft Excel 97.


MORE INFORMATION

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

NOTE: By default, the RefEdit control is not available in the UserForm Toolbox. To make the RefEdit control available in the Toolbox, use the following 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 the RefEdit.Ctrl check box, and then click OK.


The RefEdit control is displayed in the Toolbox.

For additional information, please see the following article in the Microsoft Knowledge Base:
Q158402 XL97: Using the RefEdit Control with a UserForm


REFERENCES

For more information about using a TextBox control in a UserForm, start the Visual Basic Editor, click Office Assistant, type TextBox, click Search, and then double-click "TextBox Control".

Additional query words: XL97 user form vbe text

Keywords : kbtool kbui kbdta xlui KbVBA
Version : WINDOWS:97
Platform : WINDOWS
Issue type :


Last Reviewed: October 25, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.