Call Stack Available ?
There is no way of accessing the call stack from VBA.
For widely distributed addins I maintain my own global VBA stack array
by adding the name of the function/sub into an array at the start and
subtracting it at the end. Then the error handling can display where
the error has occurred.
I also use line numbers and ERL to display the line the error occurred
on.
regards
Charles
When browsing the Locals Window, I happened upon the call stack display.
I looked in Help but could not find a way to access it with VBA.
It might be handy in error processing in knowing how you got somewhere.
If it's available, how do you access it?
Thanks.
|