Auto Generate Procedures and Codes and Syntax for VBA Editor

[Parikshit Koya]

Hi,

I am working on a few complex projects (and will be doing so in the future as well) and there is a requirement to repeat certain things multiple times, like add loops and comments. I was wondering if there is any way that I can design an add-in to do this for me within the VBA Editor (I mostly work on Excel).

I have seen add-ins like these available online as a paid version. The best and most illustrative example I could find is this one:

VBA Code Examples Add-in - Free Download for Excel

Just wanted to understand what it would take to create something similar which would at least help me generate basic comments, worksheet functions, loops, etc.

Any guidance would be very appreciated.

Thanks in advance.

Parikshit


Parikshit Koya

Continue reading...