Error messages (VBA generally (my is O2K, UK))

Topic

New Reply

Hi,

This may be one of the silly ones…

Would anyone know, if it is possible to get an error message to display, in eg. a variable, both the name of the module and the name of the procedure that caused the error… ??

Thanks,
;o)) Henrik

Reply | Quote

Replies

There is no standard feature in VBA to do what you want. You can create your own error handling, or use a utility for this. Office Developer Edition has an add-in for creating error handlers, and you can also use MZ Tools for this (free).

Home-grown error handling could look like this:

(in a module basUtilities)

Sub MyProcedure()
On Error GoTo ErrHandler

… ‘ Your code here

ExitHandler:
‘ Cleaning up here
Exit Sub

ErrHandler:
MsgBox Err.Description, vbExclamation, “basUtilities – MyProcedure”
Resume ExitHandler
End Sub

Reply | Quote

Thanks Hans,

Feared you would say this…
Having to add it as separate code does take a bit of the flexibility out of it. (Then I have to code modName and ProcedureName anyway – somewhere…)

What I had hoped for was to be able to do something like Err.Number & “:” & Err.Description & ” (” & Err.modName & “;” & Err.ProcName & “)”
– but apparently this is not a way forward – pitty though.

;o)) Henrik

Reply | Quote

If you look up the Err object in the online help, or in the Object Browser (F2), you will see that it has a property Source, but that is the entire “project” (Word doc, Excel workbook, …). There are no properties that refer to the procedure or module.

Reply | Quote

I had noted exactly that and thought the logical extension would be modName and ProcName
– but I couldn’t find these so apparently MS thought otherwise, my second hope was then that some of you clever guys out there had made some sort of a tweak for this…

Thanks anyway

Reply | Quote

Take a look at the EH procedure written by st3333ve in post 280572 – it is in the Access forum but should work in VBA in other apps too. You need to set a reference to Microsoft Visual Basic for Applications Extensibility 5.3 in Tools | References…

Reply | Quote