Unlike VBScript, VBA has its own native editor that can be accessed from the Developer tab, which is hidden by default. It can be enabled in MS Office options in the Customize Ribbon menu:
It supports debugging the code in this way, making both static and dynamic analysis relatively straightforward.
Another tool that can extract macros from documents is OfficeMalScanner, when executed with the info command-line argument. Apart from this, the previously mentioned tools from the oletools project (especially olevba and oledump) can be used to extract and analyze VBA macros as well. If the engineer wants to work with p-code instead of source code for some reason, the pcodedmp project aims to provide the required functionality. Finally, ViperMonkey can be used to emulate some VBA macros and, in this way, help handle obfuscation.