Class QuickAnalysis (Excel VBA)

Enables single-click access to data analysis features such as formulas, conditional formatting, sparklines, tables, charts, and PivotTables.

Item

To use a QuickAnalysis class variable it first needs to be instantiated, for example

Dim qas as QuickAnalysis
Set qas = Application.QuickAnalysis

QuickAnalysis class variables can be set using the Application.QuickAnalysis procedure.

Hide

Hides specific members of the Analysis Lens user interface.

When the argument is set to any one of the following options, the resulting user interface is hidden:

Hide (XlQuickAnalysisMode)

XlQuickAnalysisMode: Indicates for which top level button the callout user interface is displayed. Can be one of the XlQuickAnalysisMode constants.

Application.QuickAnalysis.Hide

Show

Displays specific members of the Analysis Lens user interface.

Show (XlQuickAnalysisMode)

XlQuickAnalysisMode: Indicates for which top level button the callout user interface is displayed. Can be one of the XlQuickAnalysisMode constants.

Application.QuickAnalysis.Show