Roll Your Own Matrix, Part 2
If my last post bored you, there is no hope for you. I dare say that you should be voting Democrat as you will be living off welfare checks for the rest of your life by ignoring my advice.
If my last post intrigued you, and you said “hey, why don’t I learn a little programming, as a hobby of sorts” – this post is for you.
Let me again sell the merits of VBA, from a coding perspective.
- You can “program” with no code at all, or use the Macro Recorder as a testing tool. If you want to do something but don’t know how to code it, use the Macro Recorder to do it first. Or, if you just don’t want to take the time to code, you can use the Macro Recorder for that.
- VBA was designed as a teaching language. It’s called “BASIC” for a reason. It’s so easy a caveman can do it, metaphorically speaking.
- The same syntax is used for every Office application. Word, Excel, Outlook, PowerPoint, Access, Visio, etc., etc. all use VBA in its standard form. Obviously, certain programming “objects” are different depending on the program (Excel deals with cells while Word uses paragraphs), but the style remains consistent.
- Intellisense. Like predictive text for your phone, the VB Editor attempts to divine what you’re trying to do. You don’t have to remember a specific object or property – the Editor will attempt to help you through that. Crucial for those who don’t want to have print-outs of programming vocabulary.
- VBA scripts can be automated or called on demand. Say, for instance, that I want a specific format to be applied to a word. Let’s say that every time I type “government,” I want it highlighted in red and black with devil ears on the side. I can have the program do that formatting every time it sees “government,” or I can have that program called at the press of a button. Your call.
If you’re looking to start with VBA for Word, look here for more.
If you’re looking to start with VBA for Excel, look here for more.
If you’re looking to start with VBA for Outlook, look here for more.
If you’re looking to start with PowerPoint or Access, don’t. While they work just the same, PPT and Access are not as easy to code given their nature. Word, Excel or Outlook would be better for first attempts.
Enjoy…

