How to Run Macro from VBA Editor
Follow the below steps to run a macro in VBE:
Step 1. Open Excel
Step 2. Go to Developer>> Visual Basic – to open VBA Editor [keyboard shortcut – Alt+F11]
Step 3. Select anywhere in the macro code and click the “Run button” (Green Arrow) or Press F5
How to Enable & Run a Macro in Excel? 6 Ways
We can record a macro in Excel or write from scratch in VB Editor. Excel provides different options to run a macro. In this article, we explore four different approaches to running a macro in an Excel application.
Even while executing an Excel macro is a straightforward process for seasoned users, it might not be clear to newbies. You will discover numerous ways to execute macros in this article, some of which may entirely alter the way you interact with Excel files.
The below macro will write the text “Geeks for Geeks” in cell B5
Sub updateText()
ActiveSheet.Range(“B5”).Value = “Geeks for Geeks”
End Sub
Contact Us