MyEducator - VBA Spreadsheet Automation Module

Authors

Dr. Mark Keith, PhD

Brigham Young University

Dr. James Gaskin, PhD

Brigham Young University

Contributors

Alayna Een

Editor

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

The course reader looks great on desktops, laptops, tablets, phones, and just about any other device.
Advanced Analytics

Monitor the progress of your class collectively as well as students individually.
Flashcards

Flashcards are a great way to learn the key terms. Each course comes pre-loaded with cards for every term.
Searchable Glossary

A searchable glossary is available at any point in the course reader.
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.

VBA Spreadsheet Automation Module

Table of Contents

Authors

Contributors

Any Device, Any Location

Advanced Analytics

Flashcards

Searchable Glossary

Highlights and Notes

Text, Video, Audio, Assessments