VBA with Macro

VBA with Macro

Course Overview
Link Copied!

Broadway Infosys, Nepal's premier IT training institute, presents an intensive VBA with Macro training program designed to equip students with essential skills in Excel automation and Visual Basic for Applications (VBA) programming. This course offers a comprehensive exploration of spreadsheet automation, from recording macros to creating custom functions and forms. With Broadway Infosys, participants will delve into the core concepts of VBA, develop proficiency in data manipulation, and harness the power of automation to streamline Excel workflows effectively.

Why Learn VBA with Macro?

VBA with Macro training complements Excel proficiency by enabling users to automate repetitive tasks, increase productivity, and unlock advanced features not readily accessible through standard Excel functions. Participants will learn to develop custom solutions tailored to organizational needs, enhancing their versatility and marketability in today's competitive job market.

Benefits of VBA with Macro

  • Enhanced Productivity: Automate tedious tasks and apply Excel VBA to streamline workflows to save time and create efficiencies in data analysis and reporting
  • Creating Custom Solutions: Build your functions, forms, or add-ins to meet specific business needs so you can face some tough challenges on your own
  • Advanced Data Manipulation: Learn to work with objects, arrays, ranges, and charts to manipulate and visualize data precisely
  • Error Handling:Learn how to debug code and handle errors to allow VBA programs to execute smoothly and perform robustly

Benefits of VBA with Macro at Broadway Infosys

  • Experts with a decade of experience as instructors
  • Learn to automate repetitive tasks in Excel with VBA and Macros
  • Gain hands-on experience applying real-world Excel automation projects
  • Increase productivity through custom functions and interactive user forms
  • Training under the guidance of domain experts with practical VBA knowledge
  • Sufficient training resources
  • Excellent training cost with scholarships available for deserving students
  • Placement opportunity for deserving trainees
  • Boosts your resume with a valuable technical skill in high demand

Our graduates are hired by 350+ companies in Nepal

Time for you to be the next hire. With our advanced and industry relevant courses, you are on the right stage to start your dream career.
Our graduates are hired by

Lesson 1:

  • Recording Macros
  • Recording and Running Macros Recording a Macro
  • Running a Macro
  • Adding a Macro/Procedure to the Quick Access Toolbar The Personal Macro Workbook
  • Saving the Personal Macros Editing a Personal Macro
  • Assigning Personal Macros to the Toolbar

  • Introducing Visual Basic for Applications
  • Editing Macros in Visual Basic Editor
  • Understanding the Development Environment
  • Protect/Lock Excel VBA Code
  • Using Help

  • Understanding and Creating Modules
  • Defining Procedures
  • Naming Procedures
  • Creating a Sub-Procedure Working Using the Code Editor

  • Defining Control-Of-Flow structures
  • Using Boolean Expressions
  • Using the IfEnd If Decision Structures
  • Using the Select CaseEnd Select Structure
  • Using the DoLoop Structure
  • Using The ForNext Structure
  • Using the For EachNext Structure
  • Guidelines for Use Of Control-Of-Flow Structures

  • Understanding Errors
  • Using Debugging Tools
  • Identifying the Value of Expressions
  • Setting Breakpoints
  • How to Step Through Code
  • Working with Break Mode during Run Mode
  • Using the Immediate Window

  • Defining Objects
  • Examining the Excel Object Hierarchy
  • Defining Collections
  • Referencing Objects in a Collection
  • Using the Object Browser
  • Working with Properties
  • The With Statement
  • Working With Methods
  • Event Procedures

  • Defining Expressions and Statements
  • Expressions
  • Statements
  • How to Declare Variables
  • Naming Variables
  • Assigning Values To Variables
  • Declaring Variables Explicitly
  • Determining Data Types
  • Programming with Variable Scope
  • Harnessing Intrinsic Functions
  • Defining Constants and Using Intrinsic Constants
  • Using Intrinsic Constants

  • Creating a Function Procedure
  • Calling a UDF
  • Using a function within an Excel Workbook

  • Adding Message Boxes
  • Return Values
  • Notes Error! Bookmark not defined
  • Using Input Boxes
  • How to Declare and Use Object Variables

  • Defining VBA’s Error Trapping Options
  • Capturing Errors with the On Error Statement
  • Determining the Err Object
  • Coding an Error-Handling Routine
  • Using Inline Error Handling

  • Defining UserForms
  • Utilising the Toolbox
  • Using UserForm Properties, Events And Methods
  • Properties
  • Events
  • Understanding Controls
  • Naming Conventions
  • Setting Control Properties in the Properties Window
  • Using the Label Control
  • Using the Text Box Control
  • Using the Command Button Control
  • Using the Combo Box Control
  • Using the Frame Control
  • Using Option Button Controls

  • What is a Range?
  • Range Property of the Application
  • Cells Property
  • The SpecialCells Method
  • Naming Ranges
  • Working with Collections

  • Creating charts from worksheet data
  • Key Properties and methods of the chart object
  • Creating Charts from Arrays

  • Understanding PivotTables
  • Creating A PivotTable
  • Procedure
  • Using the PivotTable Wizard Method
  • Using PivotFields

  • What is an Array
  • Array Sizes
  • One Dimensional Arrays
  • Arrays with Multiple Dimensions
  • A word about index numbers
  • Ubound and Lbound
  • Saving arrays in names

  • Working with Procedure and Parameters

  • VBA Password Protection
  • About Macro Security
  • Macro security settings and their effects
  • Change Macro Security Settings
Earn a High Value Industry Certificate

Add this credential to your LinkedIn profile, resume, or CV to stand out to recruiters.