XL97: Cannot Use Mouse to Populate RowSource or ListFillRange (161072)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q161072 SYMPTOMS
When you use the pointer to select a cell range to populate the RowSource
or the ListFillRange property for an ActiveX control, nothing appears in
the box for either property.
CAUSE
You cannot use the pointer to populate cell range references in the
Properties window for any ActiveX control.
RESOLUTION
To enter a range reference in the Properties window, manually type the
reference. For example, if you want to set the RowSource property for a
combo box to the range A1:A5 on Sheet1, type the following for the
RowSource property:
STATUS
This behavior is by design of Microsoft Excel.
REFERENCES
For more information about ActiveX controls, click the Index tab in
Microsoft Excel Help, type the following text
and then double-click the selected text to go to the "About adding
buttons, check boxes, and other controls" topic.
Modification Type: | Minor | Last Reviewed: | 10/10/2006 |
---|
Keywords: | kbProgramming KB161072 |
---|
|