AutoVBA - Introduction


AutoVBA installs seven ToolBars directly into the Visual Basic Editor:

autovba vba addin

  1. Code Tools & Utilities - Tools to navigate, format, edit, and debug code.
  2. VBA Code Library - 230+ Pre-built code fragments. Ready to insert into your project.
  3. Code Builders - Quickly generate complex code from scratch with virtually no coding knowledge required.
  4. Custom Code Library - Add your own code, organize into folders, and share with team members.

Settings

The Settings menu is located in the VBA Tools ToolBar:

settings toolbar

settings menu

  1. AutoVBA has two primary settings when inserting code containing objects:
    1. Read the currently active workbook, worksheet, and/or range. Hard-code them directly into code (ex. worksheet("sheet1"), range("b5") )
    2. Insert object variables corresponding to the workbook, worksheet, or range (ex. ws, wb, rng)
  2. Adjust the variable names used if option 'Insert Object...' is checked.