How to Use the VBA Editor in Excel
Written by co-founder Kasper Langmann, Microsoft Office Specialist.
Excel’s Visual Basic for Applications (VBA) editor is a very powerful tool.
It lets you write and edit custom scripts that automate actions in Excel.
In fact, when you record a macro it is stored in VBA code in the VBA editor.
But writing a macro from the VBA editor directly gives you more flexibility than recording a macro in the traditional manner.
You can create better code and complete more complicated tasks by working directly with Visual Basic for Applications.