| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name/Description of error?
This VBA line...
MsgBox xlErrDiv0 ....only gives me the number/value of the error! How do I get the MsgBox to give me the name/description of the error? Something like Error(xlErrDiv0).Name? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Name/Description of error?
msgbox err.description
Cliff Edwards |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Name/Description of error?
Type "Cell Error Values" (with the quotes) into the VB editor's search field
and the first item listed in the results panel should say the say thing... select that item and it gives you some code to use to get what I think you are asking for. -- Rick (MVP - Excel) "Charlotte E." wrote in message ... This VBA line... MsgBox xlErrDiv0 ...only gives me the number/value of the error! How do I get the MsgBox to give me the name/description of the error? Something like Error(xlErrDiv0).Name? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =IF(AND(' Job Duties Description'!S50,' Job Duties Description'!S5 | Excel Discussion (Misc queries) | |||
| "Procedure declaration does not match description" error, _dblclic | Excel Programming | |||
| Get Add-in Description with VBA | Excel Programming | |||
| Add-in Description | Excel Programming | |||
| How to add UFD arguments description? | Excel Programming | |||
Hybrid Mode
