Skip to main content

VBA Spreadsheet Automation Module

Authors

Dr. Mark Keith, PhD
Brigham Young University
Dr. James Gaskin, PhD
Brigham Young University
Dr. Douglas Dean, PhD
Brigham Young University

Contributors

Alayna Een
Editor
Edition 1
(rev. 33)

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.

  • Any Device, Any Location, Any Time

    The course reader looks great on desktops, laptops, tablets, phones, and just about any other device. Students are able to read, watch, and listen how, where, and when they want.
  • Embedded, Customizable Assessments

    Your students complete assessments inline with the text, making for a seamless, engaging experience. As the instructor, you can customize existing assessments or create entirely new ones within the text.
  • Advanced Analytics

    Monitor the progress of your class collectively as well as students individually. Course analytics provide you with student engagement and performance in reading, videos, and assessments. Analytics help you focus directly on those topics or students that need it.
  • Flashcards

    Flashcards are a great way to learn the key terms. Each course comes pre-loaded with cards for every term. Students can also make their own to enhance their learning experience.
  • Searchable Glossary

    A searchable glossary is available at any point in the course reader, allowing students to search for any key term they want and jump straight to that word in the text - no matter where they're reading.
  • Highlights and Notes

    Students can highlight the text and make notes throughout the content using their touch screen or mouse.
  • Text, Video, Audio, Assessments

    Course content is provided in multiple ways, allowing your students to learn the way they learn. The HTML5-based course reader works like any other web page--the way the web was meant to be used.