Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Communicating errors from a custom function in an add-in
Excel 2003 has these perky little green triangles that will expand to show detailed error messages for built-in functions. Is there a way that I can communicate an error other than #VALUE or #N/A from my custom C++ add-in function? If there is an answer from VB that would be ok too
Thanks Thomas Smith |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Communicating errors from a custom function in an add-in
"Thomas Smith" wrote:
Excel 2003 has these perky little green triangles that will expand to show detailed error messages for built-in functions. Is there a way that I can communicate an error other than #VALUE or #N/A from my custom C++ add-in function? If there is an answer from VB that would be ok too. You can return other error XLOPERs like #NUM or #NULL but there seems to be no way to return an error message. For ManagedXLL, I have been using a separate window to log such messages. Jens. -- http://ManagedXLL.net/ Replace MSDN with my first name when replying to my email address! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom addin gives #name? errors | Excel Worksheet Functions | |||
CSE function with #VALUE errors | Excel Worksheet Functions | |||
Errors using a new function | Excel Discussion (Misc queries) | |||
if function errors | Excel Worksheet Functions | |||
HELP - Communicating between C++ and VBA | Excel Programming |