The code that we enter into the VB editor follows certain rules and conventions. In this video, we will learn not only how to write code, but also:
how to follow the right syntax,
get help,
use the right naming conventions,
how to make our code readable.
In additon, we will also, learn how to execute the compelte code in one go, and even, how to execute each line one-at-a-time.
We will check out how to write and execute code directly into the Immediate Window.
And, for the off chance that our code execution gets stuck or hung, we will learn how to pause or end the execution.
#vba #excel
Follow the rest of the series, in the below playlist:
• VBA MasterClass
00:00 Intro
00:18 Writing Code
10:54 Executing Code
12:30 Advanced Coding
19:30 Write code in the Immediate Window
20:28 Write code in the Object Module
22:05 Pausing Code Execution