Third Party Add-ins

Rubberduck - FREE

An open-source initiative to bring people together to talk about how we can make the VBE even better.
July 2023 - Version 2.5.91

link - rubberduckvba.com/features 
link - github.com/rubberduck-vba/Rubberduck 

Unit Testing with Rubberduck

link - bernardvukas.com/testing/tutorial-excel-vba-unit-testing/ 

AutoMacro

It comes loaded with code generators, an extensive code library, the ability to create your own code library.

link - automateexcel.com/automacro/ 

Code VBA

It includes a Code Explorer pane to replace the Project Explorer and lots of builders and generators

link - codevba.com/help/main.htm 

MZ Tools

Can be used with VBA (64-bit & 32-bit), Visual Studio (.NET) and VB6.

link - mztools.com/v8/features.aspx 

Smart Indenter

It can tidy up the code by rebuilding the indentation of each line. more details

link - officeaddins.co.uk/SmartIndenter