Some Limitations for Controls on Sheets and Dialogs (104303)



The information in this article applies to:

  • Microsoft Excel 97 for Windows
  • Microsoft Excel 98 Macintosh Edition

This article was previously published under Q104303

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

Modification Type:MinorLast Reviewed:8/15/2003
Keywords:KB104303