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.

--

--

Patrick Fluke

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