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