Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
AutoAttach Property
AutoCorrect Property
AutoExpandListRange Property
AutoFilter Property
AutoFilterMode Property
AutoFormat Property
AutoFormatAsYouTypeReplaceHyperlinks Property
AutoLayout Property
AutoLength Property
AutoLoad Property
AutoMargins Property
AutomaticStyles Property
AutomationSecurity Property
AutoPercentEntry Property
AutoRecover Property
AutoRepublish Property
AutoScaleFont Property
AutoScaling Property
AutoShapeType Property
AutoShowCount Property
AutoShowField Property
AutoShowRange Property
AutoShowType Property
AutoSize Property
AutoSortField Property
AutoSortOrder Property
AutoText Property
AutoUpdate Property
AutoUpdateFrequency Property
AutoUpdateSaveChanges Property
AxisBetweenCategories Property
AxisGroup Property
AxisTitle Property
Expand Minimize

Active Property [Excel 2003 VBA Language Reference]

Office 2003

Returns a Boolean value indicating whether a


object in a worksheet is active—that is, whether the active cell is inside the range of the ListObject object. Read-only Boolean.


expression Required. An expression that returns a




Because there is no Activate method for the ListObject object, you can activate a ListObject object only by activating a cell range within the list.


The following example activates the list in the default ListObject object in the first worksheet of the active workbook. Invoking the Activate method of the


object without cell parameters activates the entire range for the list.
Function MakeListActive() As Boolean
    Dim wrksht As Worksheet
    Dim objList As ListObject
    Set wrksht = ActiveWorkbook.Worksheets("Sheet1")
    Set objList = wrksht.ListObjects(1)

    MakeListActive = objList.Active
End Function

Applies to | ListObject Object

© 2015 Microsoft