XlQuickAnalysisMode enumeration (Excel)

Indicates for which top level button the callout user interface is displayed.

Members

Name Value Description
xlLensOnly 0 Show the button but no callout user interface
xlFormatConditions 1 Conditional Formatting
xlRecommendedCharts 2 Charts
xlTotals 3 Totals
xlTables 4 Tables
xlSparklines 5 Sparklines

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.