Not true. You definitely can get the procedure name for use in error handling
I use the following:
Code:
Exit_Handler:
Exit Sub
Err_Handler:
Dim strProc As String
strProc = Application.VBE.ActiveCodePane.CodeModule.ProcOfLine(Application.VBE.ActiveCodePane.TopLine, 0)
MsgBox "Error " & Err.Number & " in " & strProc & " procedure: " & Err.Description
Resume Exit_Handler
This code requires the VBA reference library Microsoft Visual Basic for Applications Extensibility 5.3
NOTE: This doesn't always work reliably in the Form_Open event - otherwise its worked fine for me for several years
I originally found that code on the late Chip Pearson's excellent website: http://www.cpearson.com/Excel/VBE.aspx
EDIT: I see that code was the final suggestion in the link already provided