This post may contain affiliate links. Please read my disclosure for more info:

1.1 Enable the Developer Ribbon

Beginning VBA

Beginning VBA

Previous Part: 1.0 What is VBA?

 

Before we can get stuck-in with writing Macros with VBA we first have to turn on the Developer Ribbon.  The Developer Ribbon is the place where all of the VBA tools are kept.  It is unlikely that this is enabled, unless your IT department or you has previously enabled it.

Look at the top of your Excel Window if you see the word “Developer” in the menu options, then you are ready to go.  You can skip straight ahead to the next part.  However, if the Developer Ribbon is not there, just follow these instructions.

 

File -> Options -> Customize Ribbon

customiseribbon

A new window will open, ensure the Developer option is ticked in the box.

developerticked

Click OK.

That’s it.  The Developer Ribbon should now be visible at the top of the Excel window.

 

Previous Part: 1.0 What is VBA?

Next Part:1.2 Using the Visual Basic Editor

Leave a Reply

Your email address will not be published. Required fields are marked *