Question debug step into VB.Net from an Excel VBA function

Keith Howard

Active member
Joined
Jan 28, 2010
Messages
28
Programming Experience
5-10
Hello,

In previous versions of Excel, I have been successful at writing custom "=" functions in cells that called a VBA function (stored in the same .xlsm workbook as the ?=? function) that, in turn, called my Visual Basic Dot Net code. I was able to put a break on a code line in the VBA function, go back to the Excel workbook interface, press F9, then see the code stop on the break line the VBA function, then I could single step into the Dot Net code.

I do not seem to be able to do this anymore. I can?t figure out whether something has changed in Excel 2013 or whether I am forgetting an important step.

Currently, I am still able to put a break point in the VBA function, but I get a compile error regarding a reference to my VB Dot Net code. I can?t seem to reference the Dot Net code successfully.

Does anyone have any clues? Or has anyone seen any articles explaining how to do this? I think that I may need to start from scratch again to re-learn the basic process.

Many thanks in advance.

Kind regards,

Keith
 
Back
Top