Error Codes

[chrisguk]

Is there a way to print the number of an error code on the OnError event?

 

[jdraw]

I have one on a combo's AfterUpdate event

Combo0_AfterUpdate_Error:

MsgBox "Error " & Err.number & " (" & Err.Description & ") in procedure Combo0_AfterUpdate of VBA Document Form_Form11"

There is a free utility called MZTools for VBA.
It is available here.

http://www.mztools.com/v3/mztools3.aspx

It has many features, one of which is to add an Error Handler to a routine.

This has many other features, and if you don't have it, you should.

Very highly recommended.