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.
Excel Basics
·
Module 11
Advanced VBA and Client Solutions
1
UserForm Fundamentals: Building with Common Controls
Design and create a UserForm with common controls (text boxes, combo boxes, buttons).
2
UserForm Data Validation and Transfer to Worksheet
Write VBA code to validate and transfer data from a UserForm to a worksheet.
3
Automating Report Generation and Formatting
Write a procedure to automate the creation and formatting of a report from raw data.
4
Importing Data from a Text File
Automate the process of importing data from a text file into a worksheet.
5
Exporting a Worksheet Range to CSV
Automate the process of exporting a worksheet range to a new CSV file.
6
Automating Outlook Emails with VBA
Write a VBA procedure to generate and send an email via Microsoft Outlook.
Previous module
Intermediate VBA Programming
Next module
Building and Delivering Professional Tools