Function Wizard in Excel Add-in VBA (Visual Basic for Applications)

FunctionWizard

Function Wizard is a method which runs a Excel in-built function dialog at the upper left of selected cell range by which user can built its own function by following steps given in the wizard. Function Wizard is very useful and powerful feature offered by excel which an individual can use to built complex formulas.

Code example

Public Sub FunctionWizardExample()
    'Declare Range object
    Dim oRange As Range
    
    'Bind active cell
    Set oRange = Selection
    
    'Show function wizard
    oRange.FunctionWizard
    
    'Memory cleanup
    Set oSheet = Nothing
End Sub

Output

Note: Code will resume back once Function Wizard dialog dismissed by the user by hitting OK or Cancel button.

Leave a Reply

Your email address will not be published.