Tag Archives: Debugging

Stepping through Python code called from Excel

Posted on 31/03/2020 by dougaj4

Setting up your editor to allow Python code debugging for functions called from Excel can be tricky, depending on the details of your editor and linking software, but using the Visual Studio Code Editor and Pyxll, this works for me: … Continue reading →

Posted in Computing - general, Excel, Link to Python, PyXLL, UDFs | Tagged , , , , | 4 Comments

Debugging VBA – 2

Posted on 11/07/2011 by dougaj4

Following on from the opening post in this series (Debugging VBA) I will now look at the main debugging tools provided in the Visual Basic Editor (VBE): The Immediate Window allows interaction with the code while it is running.  In the … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , , | Leave a comment

Debugging VBA …

Posted on 22/06/2011 by dougaj4

… especially User Defined Functions (UDF’s). This post (and most likely several to follow) was prompted by a recent discussion at Daily Dose of Excel about various alternative debugging techniques.  It reminded me (if I had ever known) of the Debug.Assert … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , | 2 Comments