Code Inspection: Rubberduck has multiple categories of code inspection that point out possible issues and allow you to improve your code quality with usually a single click.Very useful if you have modules with a lot of code and many functions! It doesn’t stop at the module level but allows to quickly jump to a specific function or variable declaration.

Navigation: Rubberduck’s Code Explorer is a modern replacement for the built-in Project Explorer.Indentation: Automatically indent your code either on function, module or project level.Refactoring: You can easily rename functions and add, remove and reorder function arguments.It covers a lot of functionality with the most important ones being: Rubberduck is probably the most prominent free VBA add-in. And just because Microsoft hasn’t invested in either the language itself nor the VBA editor during the last 20 years, it doesn’t mean that you can’t pimp your VBA coding experience with a few extra tools! Table of Contents

Despite all the new possibilities to program Excel (like JavaScript add-ins, VSTO and others), VBA remains the most popular language when it comes to automate and enhance Excel.

Microsoft code writer