Excel VBA Macros: Custom Functions and Structures

Excel VBA Macros: Custom Functions and Structures

This course is part of Programming and Data Wrangling with VBA and Excel Specialization

Instructor: Bill Rosenthal

Access provided by Syrian Youth Assembly

4 modules

Gain insight into a topic and learn the fundamentals.

7 hours to complete

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

7 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

Write custom, reusable Excel formulas by defining input parameters, implementing If...Then...Else logic, and utilizing Select Case control blocks.
Manage memory and data structures using explicit variable declarations, strong data typing, Option Explicit, arrays, and iterative collection loops.
Troubleshoot runtime exceptions and improve macro execution speed.
Data files for this course are provided in the first course of this specialization, "Excel VBA Macros: Automating Tasks".

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

1 assignment

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Programming and Data Wrangling with VBA and Excel Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 4 modules in this course

In this course, you'll continue developing your VBA skills in Excel by creating custom functions, making decisions in code, working with variables, and performing repetitive tasks. You'll also debug VBA errors, deal with errors, and improve macro performance. Then, you'll prompt the user for more information and configure macros to run automatically.

While VBA enables you to create macros, which automate repetitive tasks, another major use of VBA in Microsoft® Excel® is to write custom functions, which you can then use in a cell formula like you would use VLOOKUP, DSUM, and Excel's other built-in functions. The ability to create your own custom worksheet functions enables you to streamline your worksheet formulas and perform tasks that are difficult or complicated using built-in functions alone.

What's included

1 reading6 plugins

As you start developing functionality in your macros and custom functions, inevitably you'll encounter problems—procedures that don't work or don't work as you expect them to, or performance issues that make some tasks take longer than you think they should. Fortunately, there are many tools and strategies you can employ to improve your VBA code.

What's included

5 plugins

Recorded macros typically run when the user chooses to run them, and then they play back the same way each time they run. However, you may want to make your macros more flexible and diverse, pausing to allow the user to select various options regarding how the macro should run. Or you might want to make some macros even more automatic; for example, running anytime the user changes the value in a particular cell, or every time a workbook is first opened. In this lesson, you'll examine various ways to control how and when macros run.