Getting sub name as parameter

  • Thread starter Thread starter dhstein
  • Start date Start date
D

dhstein

I want to write a function that will log some types of unexpected database
conditions (e.g. a Dlookup returns a null value). One of the arguments will
be the name of the subroutine that's calling the function so I can track down
where the condition occurred. Instead of hard-coding the name, is there a
way of getting the name of the subroutine in VBA ? Thanks for any help on
this.
 
hi,
I want to write a function that will log some types of unexpected database
conditions (e.g. a Dlookup returns a null value). One of the arguments will
be the name of the subroutine that's calling the function so I can track down
where the condition occurred. Instead of hard-coding the name, is there a
way of getting the name of the subroutine in VBA ?
Click to expand...
No, it's not possible.

You may use a tool like mztools.com which can provide method templates,
this will at least reduce the amount of code to type.


mfG
--> stefan <--
 
Back
Top