Microsoft Office Tutorials and References
In Depth Information
After you’ve created your list, you can begin typing data into the insert row , where the
leftmost cell contains an asterisk. Pressing the Tab key moves you to the next column, whereas
pressing the Enter key creates a new row in the list. Once you have data in the list, you can use
the down arrow buttons in the first row (usually the header row) to filter the values in your
list as if you had created an Advanced Filter. You can add a total row to the list by clicking any
cell in the list and then clicking Data, List, Total Row. Clicking a cell in the total row displays
a down arrow button that you can click to select the function you want to use in each total cell.
Note If you no longer want to use the list functionality but do want to retain the data in
the list, click any cell in the list and then click Data, List, Convert to Range.
Creating Data Lists Programmatically
Individual data lists are represented in the Excel object model by the ListObject object, which
has a variety of properties and methods that you can use to manipulate your lists using
Microsoft Visual Basic for Applications (VBA). Table 26-1 summarizes the ListObject object’s
properties and methods.
Table 26-1. Properties and Methods of the Object
Property or Method
Description
Property
Active
This property returns a Boolean value that is True if the active cell
is within the body of the ListObject .
DataBodyRange
This property returns a read-only Range object that refers to the
list’s cells between the header row and the insert row.
DisplayRightToLeft
This read-only property returns True if the worksheet, the list, or
the window is displayed in a language that displays characters
from right to left.
HeaderRowRange
This property returns a read-only Range object that refers to the
cells in the header row of the ListObject .
InsertRowRange
This property returns a read-only Range object that refers to the
cells in the insert row of the ListObject .
ListColumns
This property returns a ListColumns collection that contains all the
columns in the ListObject .
ListRows
This property returns a ListRows collection that contains all the
rows in the ListObject .
Name
A property used to identify the ListObject as a unique member of
the ListObjects collection. The Name property can only be set and
read using VBA; you can’t affect it using the Excel interface.
continued
Search JabSto ::




Custom Search