Microsoft Excel Training Videos
Writing a Macro using VBA code in Microsoft Excel
To write a macro in Microsoft Excel you need a knowledge of the programming language Visual Basic for Applications. Visual Basic for Applications is easy to learn and gives you a powerful tool to automate your work in Microsoft Excel. Also you can create new applications in Microsoft Excel if you can write macros.
Click on Tools in the menu bar.
Select Macro.
Select Visual Basic Editor.
In the Visual Basic editor window, select 'Insert' from menu bar.
Select Module.
Start writing your code as demonstrated. This macro calculates the 'Perks' and the 'total'
After completion, click on the run button in the 'tools' bar as shown in the Excel training video.
Further reading on VBA
Excel VBA
Microsoft Excel Training Videos
