The first step to working with VBA in Excel is to get yourself familiarized with the Visual Basic Editor (also called the VBA Editor or VB Editor). In this tutorial, I will cover all there is to know about the VBA Editor and some useful options that you should know when coding in Excel VBA.
Visual Basic Editor is a code editor for VBA. It’s a separate application but you can only use it with Excel. You need to have the developer tab on the ribbon to access it. You can also use the keyboard shortcut (Alt + F11). It also stores the macros that you recode with the macro recorder.