Purpose

Returns a summary of all the summary rows identified during drilldown.

Syntax

objVelixo.GetGLDrilldownSummary Cell

objVelixo - a variable that represents an instance of the Velixo VBA functions class.

Parameters

Name

Description

Cell

Required. Excel.Range to act upon. Must be a single cell.

Remarks

Returns a list of GLDrilldownSummary objects. The following properties are available in this object: Account, Branch, Connection, Ledger, SourceAddress Subaccount.

This function can be used to create your own custom drilldown tab, or to dynamically expand a report based on the selected row. A complete example can be found in this file: RapidByte Macros Sample.xlsm

Example

Dim velixoObj As Velixo_Reports.VBA
Set velixoObj = CreateObject("Velixo.Reports.Vba")

If Selection.Cells.Count > 1 Then
MsgBox "Only one cell can be selected at once.", vbCritical
Exit Sub
End If

For Each data In velixoObj.GetGLDrilldownSummary(ActiveCell)
MsgBox data.Account & "-" & data.Subaccount
Next
Did this answer your question?