Getting Used to the Developer Toolbar

Now that you have completed a basic level of knowledge of VBA tools and terminology, let’s start by opening the developer toolbar before we go any further. There will be other terminology coming up, however, let’s switch to a few more active activities so that you don’t always have to just be looking at words without doing anything.

The easiest way to start the process is to make sure that you have the Developer ribbon attached to the top of Excel. This will ensure that you have always access the developer bar when you either need to create a new code, or when you need to use a code that you have already created in the past. To do this, click on the round Office button, the click on Options, and then click on “Top options for working with Excel”. You will see a box called “Show Developer tab in the Ribbon”. Click on this option to turn it on. Now, go to Excel’s File menu and click on Options. Click on Customize Ribbon, and then check the box that is named “Developer”. You will now see many new tools appear in the Excel Developer Ribbon above. It may take you a bit of time to familiarize yourself with all of them, but once you do, you will be on a whole new journey to making the most of Excel’s macros and the VBA system.