VBA Macros

VBA Macros course is offered by L&D Edutech. We at L&D Edutech are driven by Passion, passion for excellence in education, passion for excellence in customer service, and passion for excellence in whatever we do.

We are a team of individuals having more than 2 decades of combined experience in the field of vocational training. We have built our career ground up and understand the aspiration value of students who come to us for career building and/or career enhancement.

Content:

• Introduction to VBA
• What Is VBA?
• What Can You Do with VBA?
• Recording a Macro
• Procedure and functions in VBA
• Variables in VBA
• What is Variables?
• Using Non-Declared Variables
• Variable Data Types
• Using Const variables
• Message Box and INPUTBOX FUNCTIONS
• Customizing Ms boxes and Input box
• Reading Cell Values into Messages
• Various Button Groups in VBA
• if and select statements
• Simple If Statements
• The Elseif Statements
• Defining select case statements
• Looping in VBA
• Introduction to Loops and its Types
• The Basic Do and For Loop
• Exiting from a Loop
• Advanced Loop Examples
• Mail Functions – VBA
• Using Outlook Namespace  
• Send automated mail
• Outlook Configurations, MAPI
• Worksheet / Workbook Operations
• Merge Worksheets using Macro
• Merge multiple excel files into one sheet
• Split worksheets using VBA filters
• Worksheet copiers