Is there a VBA fiddle?

I'm looking for a scratchpad to throw code in and see if it works. Something like dotnetfiddle.net but for VBA.

if you press f8 you can step through the code or select a line and press f9 to set a breakpoint. Not sure if that helps but its what I do to test code

I usually create my own scratchpad Sub at the end of the code module where I try out stuff, I call mine Foo()

typically it's where I'll create small sections of code or try things out for the first time. it's usually littered with multiple Debug.Print lines so I can see results as I step through, or I use the locals window.

I make sure it never outputs results to the workbook so I'm never in danger of messing up any of the 'live' data. I use it work through logic and also throw in edge cases etc to ensure it's behaving as needed before I deploy it into the main workbook code.

You can get a little complicated with the Immediate Window

Please Login or Register  to view this content.

OK - so it's nonsensical but just to illustrate iterating a Do or For loop

I will start using this Immediate Window.

Wow.... 97 sheets... I don't think you can call that a workbook anymore.

... will start using this Immediate Window

Just bear in mind you are limited to statements on 1 line only... To really check out code add it as a Public Sub to a scratch module and call it from the Immediate Window or, if the procedure does not take any parameters, click the mouse anywhere in the procedure body and press F8 to start single stepping or F5 to just run it.