The reason I write this article is because my friends, and my colleagues have been asking me to write VBA for Excel after that there is this following question “How can I run it?” You can find the same question in many forum posts as well.
To run your VBA or Macro.
1. Of course, open Excel file with xlsm extension (for Office 2007 and above).
2. Click File.
3. Click Options.
4. Check the Developer.
You should see the DEVELOPER tag appears in your Excel Ribbon now.
5. Click DEVELOPER, click Visual Basic.
6. Click on the Subroutine that you want to run then click Run.