Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listing of error codes
Does anyone have a function or some code that contains the most common errors
so that when we create new macro's we can use a function or something when an error happens it pulls up the correct description of the error? I am not very good at this so if you have any other idea's please let me know. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listing of error codes
You can use err.Description to get a (short) text version of the error.
Tim "Rookie_User" wrote in message ... Does anyone have a function or some code that contains the most common errors so that when we create new macro's we can use a function or something when an error happens it pulls up the correct description of the error? I am not very good at this so if you have any other idea's please let me know. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listing of error codes
The Err object has a variety of properties, .Number, .Description, .Source
etc. that you read in an error trap: On Error Goto Handle 'Code Exit Function/sub Handler: With Err. Msgbox Number & vbNewLine & .description & vbnewline & .source 'Raise your own error .Raise vbObjectError + 513, "ThisFunction","Invalid something" End With NickHK "Rookie_User" wrote in message ... Does anyone have a function or some code that contains the most common errors so that when we create new macro's we can use a function or something when an error happens it pulls up the correct description of the error? I am not very good at this so if you have any other idea's please let me know. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Codes | Excel Worksheet Functions | |||
Excel Error codes | Excel Discussion (Misc queries) | |||
VB Error Codes - where to look? | Excel Programming | |||
Syntax error on codes | Excel Programming | |||
Syntax error on codes | Excel Programming |