Knowledge Base

Some Limitations for Controls on Sheets and Dialogs

Article ID: 104303

Article Last Modified on 8/15/2003


APPLIES TO


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

Additional query words: xl97 xl7 xl98 XL

Keywords: KB104303