locked
Auto Generate Procedures and Codes and Syntax for VBA Editor RRS feed

  • Question

  • 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:

    https://www.automateexcel.com/vba-add-in-download/

    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


    Friday, August 2, 2019 5:03 PM

All replies

  • Give some examples of he code / comments that need to be generated.

    Search Documentation

    SerialPort Info

    Multics - An OS ahead of its time.

     "Those who use Application.DoEvents have no idea what it does

        and those who know what it does never use it."    former MSDN User JohnWein

    Friday, August 2, 2019 5:15 PM
  • Hi,

    According to your description, your issue is more related about VBA. And this forum is discussing and asking questions about the vb.net.
    Ask in the following forum.
    https://social.msdn.microsoft.com/Forums/vstudio/en-US/home?forum=isvvba

    Best Regards,

    Alex


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, August 5, 2019 5:12 AM