Communicating errors from a custom function in an add-in

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Thomas Smith said:
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
Click to expand...
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is it possible to make a custom function behave like a built in on 2
Custom Function Add-In not working 4
Add-in - add a custom function to a custom group. 1
Options for error output in custom Excel functions 2
modifiying a custom lookup function 2
How to call module function or sub from the Add In? 3
ignore error 1
function with collection of custom objects as results 0

Back
Top