application.caller

Is there a way to identify which method calls another. I have a method called from several others. I would like to know which caller it was. Application.Caller is not for this. I want to do something like this. Debug.Print "In write data method." & WhoCalledIt Thanks,

Hello all, I'm new here and though pretty well experienced in data mining and spreadsheets, I'm very poor in programming. For large spreadsheets I use quite some 'Grouping' actions to make it all more compact. The Groupings are called from a button and the name of the button is such that it...

Hello all. I used the following line of code... Call Button_Differentials_ZeroOut ...to call another Button [Forms Control] and it blows up the Application.Caller in the "called" button with a "Run-time error '1004' - Unable to get the Buttons property of the Worksheet class. The specific line...

Dear all, this is my first post here and I have been using vba only for a month, so sorry for any naïve question. In my excel sheet I have a button which is connected to a macro which copies data from another workbook to the row of the button. The code is here below. I need to get the row...

In Excel VBA, if subroutine A calls subroutine B, is there a way for subroutine B to know that subroutine A was what called it? I mean this for run-time, so not talking about watch window. Application.caller seems to give info in calling VBA from Excel, not for info about a subroutine calling...