Do More With Excel and VBA

Patrick Fluke
6 min readAug 20, 2020
Photo by cottonbro from Pexels

Too many people out there think that because they know how to fill out a formula, or how to use the “Record Macro” function that they can do everything that there is to do with Excel. This mindset couldn’t be further from the truth! Honestly, combining the power of VBA or Visual Basic for Applications, and Excel, you can manipulate data in immeasurable ways.

If you have a basic understanding of how to program, using VBA will both build on those skills and let you accomplish more in Excel much more quickly than you would otherwise be able to.

VBA Sounds Like a Programming Language

VBA is absolutely a programming language. VBA works with Microsoft Office products to extend the functionality of these programs to suit any possible need you could have.

Often there are ways to attain the same results using extremely long formulas, but you may save yourself a lot of effort by learning the basics of programming and VBA.

So I Can Only Use VBA With Excel?

Microsoft Office Products work with VBA to provide you with everything you need to customize your experience. You can extend Word, Access, or even Outlook using the VBA programming language once you understand how everything works together.

For this article, the instructions provided are for Excel. However, the necessary steps will be the same or similar for all of the various Microsoft Office products.

How To Get Started

The first step you’ll need to take before working with VBA in Excel is to activate the developer tools. To do this, follow these simple steps.

  1. Click the “Customize Quick Access Toolbar Option” button on the top left-hand corner of your screen.
The red circle surrounds the “Customize Quick Access Toolbar Option” in Excel.

2. Click “More Commands” in the drop-menu that shows up.

The dropdown that shows up when you click the “Customize Quick Access Toolbar Option.”
Patrick Fluke

Freelance Writer and Programmer. Usually writing about programming or game development, but quite often side tracked. Stick around!