Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Automate Excel
·
Module 9
Core VBA Programming Concepts
1
Conditional Logic with IF...Then...Else
Write IF...Then...Else statements to introduce conditional logic into VBA procedures.
2
For...Next Loops for Repetition
Write a For...Next loop to repeat actions a specific number of times.
3
VBA for Excel: Workbook and Worksheet Automation
Reference and manipulate Workbook and Worksheet objects programmatically using VBA.
4
Working with Range and Cell Objects
Reference and manipulate Range and Cell objects using methods such as Range, Cells, and Offset.
5
Reading and Writing Cell Values with VBA Variables
Read values from cells into VBA variables and write values from variables back to cells.
Automating Cell Formatting with VBA
Automate cell formatting (font, color, borders, number format) using VBA.
7
Mastering Do...While Loops
Write a Do...While loop to repeat actions until a specific condition is met.
Previous module
Introduction to Automation with Macros
Next module
Automating Data Processing with VBA