Category Archives: VBA / Macros

Learn by Doing: Intro to VBA via Adding Charts Example

Thanks to Nick Williams at Acuity Training for this guest post! All content that follows is credited to Nick Williams, and was directly provided to Excel Exposure: This article gives people who are new to Excel VBA a very good … Continue reading

Posted in VBA / Macros | Tagged , , , , | 13 Comments

VBA PO Generator: Homework Solution Part 1

The following is a guest video lesson provided by Chris H. (reddit: Kristofmic). In this video series we’ll follow along with solutions to the advanced homework for the VBA Purchase Order Generator Walkthrough. In Part 1 of the homework solution, … Continue reading

Posted in VBA / Macros | Tagged , , , , , , , | 3 Comments

VBA Walkthrough #2: Message Encoder & Decoder

This VBA macro is hopefully a bit more interesting than the last, and shows how I created a message encryptor/decryptor in Excel using VBA/macros. The lesson covers these specific areas of VBA usage: – For…Next loop (including nested loops) – … Continue reading

Posted in VBA / Macros | Tagged , , , , , , , | 7 Comments

VBA Walkthrough #1: Purchase Order Generator

VBA Macro Walkthrough One of the best ways of learning VBA is to take a look at completely functioning macros & code to see how others approach a problem.  In this video lesson, I walk you through a Purchase Order … Continue reading

Posted in VBA / Macros | Tagged , , , , , , | 19 Comments

Video Lesson: Introduction to Macros & VBA

Using macros in Excel requires knowledge of Visual Basic for Applications (VBA).  In this video lesson you will get an introduction to how macros work within Excel and how to build them.  The video lesson includes the following topics: – … Continue reading

Posted in Data Input & Manipulation, VBA / Macros | Tagged , , , , , , | 28 Comments