Rubberduck – refactoring in VBA

Hi all, recently came across an interesting Rubberduck project. Did you think that VBA is dead and buried? It looks like it’s not going down that easily!

Rubberduck is a COM Add-In for the VBA IDE that makes VBA development even more enjoyable, by extending the Visual Basic Editor (VBE) with menus, toolbars and toolwindows that enable things we didn’t even think were possible when we first started this project.

If you’re learning VBA, Rubberduck can help you avoid a few common beginner mistakes, and can probably show you a trick or two – even if you’re only ever writing macros. If you’re a more advanced programmer, you will appreciate the richness of Rubberduck’s feature set.

The project’s goal is to provide a first-class coding experience, guess where – in VBA IDE. That means, finding and automatically fix code issues, refactorings in VBA – you name it.

It does seem to work with Visio VBA as well. Below are some screenshots (also the link to the feature list).

3-28-2015 3-25-30 PM


The project is open-source, so you can participate in it’s development. It does not look a rock-solid right now yet (stopped working when trying to do some refactoring on my computer a few times), but let’s see what will come out out of this!



Leave a Reply