how to open microsoft visual basic for applications excel

The second step is to save the file as Macro-Enabled Worksheet format:

Save the File as Macro-Enabled Worksheet Format If Developer is not already in the Main tab, you can find it in All Commands section and add Developer to the Main area:Īnd you will be able to see the Developer tab:Ģ. Under the Main area, make sure Developer is in this section and selected.Right now, let’s first go through how to set up Excel properly so that it is ready to use Macro/VBA: 1. We will not go through how to record Macro or how to use VBA in this article. That way we can learn the basics of how VBA language works. Tip: a simple way for anyone to start learning VBA is to record a simple Macro and then go into VBA to review the module. Once the series of activities/steps are recorded, the Macro is essentially created into a module in VBA and we can go in to review/edit the codes. It is important to note that Macro is really part of VBA. We can create user forms, automate a series of steps, create reports, send emails out and a lot more. Except, instead of recording the series of steps, we have to write them as lines of codes in modules. VBA (Visual Basic for Application) is very similar. Excel records that series of activities/processes so that with a click of a button, Excel will repeat those specific steps for us. Macro is a recording tool in Excel – we press a button to “start recording”, we then do a series of activities/processes and at the end we press a button to “end recording”. Before we start, let’s talk about what Macro and VBA are about.

To enable Macro/Visual Basic for Application (VBA) in Excel, there are two steps.

How to open microsoft visual basic for applications excel