Creating

It is possible to create add-ins for the different applications.
All the applications do share the same (File > Options)(Add-ins tab) which displays a list of any add-ins that are available/inactive.
The exact steps though are slightly different for each application.

Excel

Create a workbook (.xlsm) containing everything and save it as an "Excel Add-in (*.xlam)".
more info
SS - save as dialog

Word

Create a document (.docm) containing everything and save it as a "Word Macro-Enabled Template (*.dotm)"
This application has the ability to record a macro.r
more info
SS

PowerPoint

Create a presentation (.pptm) containing everything and save it as a "PowerPoint Add-in (*.ppam)"
This application does not have the ability to record a macro.
[[more info]]

Outlook

You cannot create and distribute a "VBA add-in" for Outlook.
It is possible to write and run VBA code, but this functionality was really only designed for personal use, not distribution.
All code must be saved in a file called "VbaProject.OTM" and this is the only project that can be loaded into the Visual Basic Editor.
[[more info]]
SS

link - learn.microsoft.com/en-us/outlook/troubleshoot/deployment/manage-distribute-outlook-vba-project