XL: Some Limitations for Controls on Sheets and Dialogs

ID: Q104303

The information in this article applies to:

Microsoft Excel for Windows, versions 5.0, 5.0c
Microsoft Excel for the Macintosh, version 5.0
Microsoft Excel for Windows 95, version 7.0
Microsoft Excel 97 for Windows
Microsoft Excel 98 Macintosh Edition

SUMMARY

In Microsoft Excel, you can use control objects such as check boxes, option buttons, and list boxes on a worksheet or a dialog sheet. However, note the following exceptions.

Worksheets

You cannot use the following on a worksheet:

Edit boxes
Combination list-edit boxes
Combination drop-down edit boxes

Dialog Sheets

Although on a worksheet you can place multiple lines of text on a button control, button controls on dialog sheets will only display a single line of text when the dialog box is displayed.

REFERENCES

"Visual Basic User's Guide," version 5.0, Chapter 11

Additional query words: xl97 xl7 xl98


Keywords          : 
Version           : 5.00
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 6, 1999