How to find out the trigger of a function? (1 Viewer)

[KitaYama]

I have a function that can be called from a commandbar on some forms or from ribbon or from other functions and subs.

How can I check the trigger? The function has been called from a commandbar or a function/sub?

For now, I ended up deleting the commandbar after each use and recreating it when necessary. Then used a syntax like following.
Is there any simpler way to check the trigger of a function?

Public Function MyFunction (Optional Params as string)

    If isCommandBar("MyCommandBar") Then
        Params = Nz(Application.CommandBars.ActionControl.Parameter, "")
    End If

    ' Do Something Here

End Function

Thanks.

 

[MajP]

Afaik you need to pass in an optional parameter identifying the calling procedure

 

[KitaYama]

Afaik you need to pass in an optional parameter identifying the calling procedure

Instead of deleting and recreating the commandbar, based on your advice, I changed my code to:

Public Function MyFunction (Optional Params as string, Optional Trigger as string)
    
    If Trigger="" then
        ' has been called by commandbar
        .....
    else
        ' has been called by another function/sub
        ......
    End If

    ' Do common tasks Here

End Function

The code seems better than what it was.
Thanks.