Blog
Library

2 Days Live Virtual Training on Excel Macros & VBA Programming

You will be able to manage and create complicated Macros VBA programming in MS Excel from industry expert with real world examples. End of this course you will become a star Excel programmer and can write an Excel Macro by yourself.
  • Training Type
    Live Training
  • Category
    MS Excel
  • Duration
    6 Hours
  • Rating
    4.8/5
2 Days Live Virtual Training on Excel Macros & VBA Programming

Excel VBA Programming Course Introduction

About Excel VBA Programming Course

Learn VBA from the beginning steps to seeing how a maintenance application (one that runs every week or month) could be built, step by step. You will learn how to record and edit macros, get information from a user, create and use Userforms, various ways to do loops, if-then-else constructs, Select Case, Using variables, Function subroutines, and much more.

Excel VBA Programming Course Objective

To allow the user to make repetitive tasks be solved more easily; to create one's own personal set of tasks which will always be available. After this class you'll be well on your way to becoming a programmer.

Target Audience: People with a basic knowledge of Excel to advanced users. This course does start from the very beginning

Who is the Excel VBA Programming Course Target Audience?

People with a basic knowledge of Excel to advanced users. This course does start from the very beginning

What Basic Knowledge Required to Learn Excel VBA Programming Course?

Able to use Excel 

Related Virtual Classroom
Have Any Queries
Call Us : +510-849-6155
Email : support@simplivlearning.com

Available Batches

There are no upcoming batches. You can Enroll for a recorded sessions.

Pricing

Live
Single Attendee
199 332
Live Session
Recorded
Single Attendee
249 416
6 month Access for Rec
Live+Recorded
Single Attendee
299 499
6 month Access for Rec
Contact Support for Group Offers
Require a Different Batch? Let us Know

Require a Different Batch?

Request a Batch For

Excel VBA Programming Course Curriculum
Total Duration : 6 Hours
Features
  • Recording macros  
  • Editing macros  
  • Getting a message to/from the user  
  • Learning the environment (VBE)  

    Module pane 

    Immediate window 

    Project Window 

    Properties Window 

    VBA Toolbars 

Learning all about the most important object, the “Range” object
  • Cells  
  • Offset  
  • Resize  
  • Directions  
  • Union  
  • Intersection  
  • Virtual worksheet  
  • Current Region  
  • Used Range  
  • Visible Range  
  • Special cells  
  • Areas  
VBA Constructs
  • If-then-else-End if  
  • Case-End Case  
  • And/Or  
Loops
  • For/Next  
  • Do/Until  
  • Do/While  
  • While/Wend  
  • Do/Loop  
Scope of Variables (how long do they “live”?)
Creating a mini-application
  • Add records to a list by VBA  

    Checking for errors

User-defined Functions
Event programming
  • Taking action when:  

    A selection changes 

    The worksheet is calculated 

    A sheet is activated/deactivated 

    Before a doubleclick 

    Before a right-click

Creating and using Userforms
Walking through a monthly maintenance application
  • Creating it step-by-step