Book Cover

VBA Spreadsheet Automation Module

Technology Application Modules

ISBN:

978-1-959142-27-0

cfwf default

VBA Spreadsheet Automation Module

Dr. Mark Keith, PhD James Gaskin, PhD

This module walks you through the basics of spreadsheet automation through the Visual Basic for Applications programming language that underlies most Microsoft Office applications. The content starts from an assumption of zero programming experience and takes you all the way through recording basic macros and then writing dynamic and complex macros from scratch. What you learn in this module has the potential to save you and your company hundreds of hours and hundreds of thousands of dollars by automating repetitive tasks.

  • Free instructor demo access to full resource
  • Plug-and-play solution for instant adoption
  • Lifetime access for students

Course Objective

This module teaches spreadsheet automation using Visual Basic for Applications, starting from no programming experience to creating complex macros, ultimately saving time and money for individuals and companies.

Table of Contents

Chapter 1: Dev: Systems Development Life Cycle Chapter 2: Dev: Flowcharts and Algorithms Chapter 3: Dev: Introduction to VBA in Excel Chapter 4: Dev: Objects, Navigation, and Conditionals Chapter 5: Dev: Loops Chapter 6: Dev: Batch Processing and Nested Loops Chapter 7: Dev: String Manipulations

Request Free Access

Interested in using this resource in your course? Request free instructor access. Just tell us who you are and where you teach, and we’ll take care of the rest!

(students: reach out to your instructor for assistance with accessing your textbook, or view this walkthrough.)

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Made by proffessors, for professors

cfwf default

Auto-Graded Assessments

Customize assessments or create new ones. Assessments are completed online within the text and instantly graded with detailed feedback.

cfwf default

LMS Integration

Access courseware with single sign-on convenience using our LMS integration tools. Assignments, exams, and grades are automatically synced.

cfwf default

Instructor Materials

Take advantage of study plans, PowerPoint presentations, and test banks so that courses require minimal start-up time.

cfwf default

Micro-Credentials & Certificates

Allow your students to earn achievements in the classroom. Keep them engaged using ready-made badges and certificates, or create your own.

cfwf default

AI Virtual Assistant

Our AI Virtual Assistant transforms how students engage with content, offering features like multilingual translation, question answering, progress assessment, and much more.

Related Courses

Catalog
What is MyEducator?
How much does MyEducator cost?
How long do students have access, and what about updates?
Are resources customizable?
How long is setup—what is the adoption process?
What LMS do you integrate with?
Do you provide sample syllabi, guides, and other instructor materials?

Ready to get started?