I would like to write code in VBA for EXCEL that on error tells me what sub, or function I'm actually in.

Example if I'm in a sub routine that has an error. I would like to capture the subroutine name that is giving me the problem and then write that error out to a text file or actually modify the object i.e. module or function programmatically in a class routine.