I am trying to build custom user defined functions with excel-dna. What is a possible way to debug the custom functions, I.e. set breakpoints, add watch windows etc? Is it possible to do it on visual studio?
Right click the project that uses excel dna from the solution explorer in visual studio. Then click properties, and then choose Debug. Now, choose Start external program and find the path of the Excel application. In the Start options, in Command line arguments, write the name of your excel dna addin.
After this, you just need to run your project in Debug mode.