Macros 8 - VBA Variables 2024

Macros 8 - VBA Variables

After many requests I developed this one and a quarter hour session on VBA variable to explain the how, why and when to use them.

This session shows you how variables make your VBA code easier to write and understand.

Variables are an essential programming tool. They speed up code creation and your code more flexible.

Level: Intermediate
Duration: 1.25 hours
Price: AU$25

Macros 8 - VBA Variables 2024

Course
5 Lessons

This session covers variables in depth and expands on previous sessions. Learn how to make the most of variables in your VBA code. There are so many advantages to using variables, but you need to get a good understanding of them to get the most out of them. Version: All versions Recorded: May 2024 Level: Intermediate Duration: 1 hour 15 minutes Price: AU$25

Buy now

Session Materials

This session covers variables in depth and expands on previous sessions.

Learn how to make the most of variables in your VBA code. There are so many advantages to using variables, but you need to get a good understanding of them to get the most out of them.

This session covers

variable types, as well as when, how and why to use them
shortcuts that can reduce the typing involved with variables
useful examples to demonstrate variable usage
building user messages
selecting separate sheets based on user input
combining data sheets based on a criteria

Macros 8 Variables 2024.pdf

567 KB

Macros_8_Variables_2024.xlsm

152 KB

Macros_8_Variables_2024_completed.xlsm

162 KB

Session Recording - May 2024

Macros 8 - VBA Variables - video

(1h 13m 20s)
213 MB

Quiz

Test your new found knowledge with these 10 questions.

VBA Variables: Quiz