CurrentModule, CurrentClass, CurrentProcedure properties
Create these properties so that when writing VBA Code they can be easily referenced. Example MsgBox "Hello Word", vbInformation, currentModule & " - " & currentProcedure
Alan Cossey commented
I suggest you have a look at EverythingAccess.com's vbWatchdog.
In fact I suggest Microsoft buy out EverythingAccess.com and incorporate vbWatchdog into Office VBA!