List of Runtime Error Codes

[DCSwearingen]

I thought I had seen a VBA routine that would return a listing of the VBA Runtime error codes and what they mean.

I know I have seen such a routine in Access97 VBA, but am not sure it will work in Excel.

I am not sure this is even possible, but if it is would it be possible to post the code that will return a list of the codes and what they mean?

If it isn't possible, please let me know that as well.

One more thing...
This is not a cross post, as I had posed a similar question in the Miscellaneous Forum, but I deleted that post as I realized it was in the wrong forum.

[VBA Noob]

Does this link help

http://support.microsoft.com/kb/146864

VBA Noob

[DCSwearingen]

This is the list I was looking for.

For some reason I thought there was a VBA routine that would return the list to an Excel sheet, but this works for me!!

[MSC_GG]

Hello,
Sorry to unearth this old thread.

For some reason I thought there was a VBA routine that would return the list to an Excel sheet

Indeed there is a way in Excel to programmatically retrieve a listing of all VBA built-in runtime errors that are available on your platform. For example, you can paste the code below in a module of an empty workbook (successfully tested in Excel 2007).

Note that I parse error codes from 1 to 1000 (see variable MaxErrNo): that’s because, in my Excel 2007, the highest built-in error code is 746. But you can actually parse the error codes up to 65535 (see the link already posted by VBA Noob), it will just take longer to execute the macro.

Please Login or Register  to view this content.

Of course this could be improved by handling unexpected errors, adding a button on the 1st worksheet, displaying progress, storing the error codes and descriptions in a Dictionary object, etc.