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
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
