Notitie
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen u aan te melden of de directory te wijzigen.
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen de mappen te wijzigen.
Returns Boolean to indicate whether the AutoFilter will be displayed. Read/write Boolean.
Syntax
expression.ShowAutoFilter
expression A variable that represents a ListObject object.
Remarks
The ShowAutoFilter property defaults to True for a new ListObject object.
Example
The following example displays the setting of the ShowAutoFilter property of the default list on Sheet1 of the active workbook.
Dim wrksht As Worksheet
Dim oListCol As ListColumn
Set wrksht = ActiveWorkbook.Worksheets("Sheet1")
Set oListCol = wrksht.ListObjects(1)
Debug.Print oListCol.ShowAutoFilter
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.