VBA Macros Basic To Advance Training

VBA Macros course is offered by Webs Jyoti. We have trained over 10,000 participants hail from various backgrounds and industries, including corporate professionals seeking to enhance their skill set, as well as students embarking on their educational journey.

Content:

• INTRODUCTION TO VBA
• 1. What Is VBA?
• 2. What Can You Do with VBA?
• 3. VBA IDE
• 4. Recording the Macro
• VISUAL BASIC EDITOR
• 1. The Project Explorer
• 2. The Properties Window
• 3. The VB editor windows
• 4. Creating and Removing Modules
• VARIABLES IN VBA
• 1. What is Variables?
• 2. Using Non-Declared Variables
• 3. Variable Data Types
• MESSAGEBOX AND INPUTBOX FUNCTIONS
• 1. Customising Msgboxes and Inputbox
• 2. Concatenating Boxes
• 3. Using Multiple Lines
• 4. Reading Cell Values into Messages
• 5. Asking Questions with Msgboxes / Inputbox
• VBA WITH STATEMENTS
• 1. Writing a Simple With Statement
• 2. Creating More Complex References
• 3. Referencing other Objects
• IF STATEMENTS
• 1. Simple If Statements
• 2. Single line Ifs
• 3. The Elseif Statement
• 4. Nesting Ifs
• 5. Combining Logical Tests
• LOOPING IN VBA
• 1. Introduction to Loops and its Types
• 2. The Basic Do Loop Statement
• 3. Exiting from a Loop
• 4. Advanced Loop Examples
• FOR NEXT LOOPS
• 1. Using Loop Counters
• 2. The Step Keyword
• 3. Exiting from a For Next Loop
• 4. Looping Through Items in a collection
• FOR EACH LOOPS
• 1. The For Each Next Statement
• 2. Looping Over Cells
• 3. Nesting for Each Loops
• CREATING FUNCTIONS
• 1. Writing a Simple Functions
• 2. Calling Functions
• And more.