VBA and Macro for Excel Automation
Created by Sudoksho
Course Duration 45 Days ৳1490
Effort Time 1/2 Hours Days
Last updated Jul 19, 2020
13 Modules
14 Exams
0 Files
35 videos
2 Trainee
Course Overview
VBA and Macro for Excel Automation
Section-1: Introduction of VBA & Macro
Section-2: Recording and Running the Macro
- S02 1 What is VBA and Macro
- S02 2 Example of few ready real files created using VBA and Macro
- S02 3 Configuring Excel to start VBA and Macro
- S02 4 Creating macro using macro recorder
- S02 5 Running the macro clicking on a button
- S02 6 Running the macro by shortcut key
- S02 7 Saving steps of the Macro enabled file 1
Section-4: Common Visual Basic Concepts and Environments
Section-5: Creating and Executing Subroutine
Section-6: Creating and Executing Events
Section-7: Creating MessageBox and InputBox
Section-8: Creating Using UserForm in Excel
Section-9: Inserting Various Form Controls on UserForm
Section-10: Error Handling and Debugging Techniques
Section-11: A Complete Project to Create a Data Entry Form
Section-12: Creating User Defined Function (UDF)
Section-13: Creating and Executing Add-ins in Excel