VBA MACRO

VBA Macro Programming & Automation

  • Macro Recording and Running
  • Programming Concept
  • Developer Tab and Menu
  • Recording a Macro
  • Saving Macro in Different Workbooks
  • Various Methods of Running a Macro
  • Command Button
  • Design Mode
  • Running Mode & Break Mode
  • Modules and Procedures
  • Absolute and Relative Reference

Introduction to Visual:-

  • Basic Editor
  • Project Explorer and Code Window
  • Modules
  • Functions and Subroutines
  • Worksheet Properties in Property Window

Programming Basic

  • Public and Private Subroutines
  • Object
  • Methods and Properties
  • Object Hierarchy & Collection
  • Creating a Folder/Subfolder
  • Opening , Saving, Closing New Workbook
  • Opening a saved Workbook
  • Selecting/Activating/Renaming/Adding Sheets
  • Range, Cells, Columns & Row Properties
  • Writing a Simple Code in VBA

Variables and Data Types

  • VBA Data Types
  • Variables and Constants
  • Numeric and String Types
  • String and Date
  • Boolean, Long, Integer, Byte, Double, Single, Currency
  • Working with Arrays
  • Working with Arrays
  • Single line Decision
  • Nested Line Decisions
  • Single Line Case
  • Nested Line Case
  • IIF, If and Then Statements
  • IIF, If and Then Statements
  • Looping -
  • DoLoop, For Next Loop , For Each Loop
  • Data Compilation
  • Conditional Data Compilation
  • Conditional Sheet Add
  • Looping through Object
  • Looping Sheet
  • Looping Workbook
  • Looping file & Folders
  • While Wend Loop
  • Do Until Loop
  • Some Useful Formula Using Loop

Dialog Boxes and User Form

  • Massage Box
  • Input Box
  • Using Loop in Input Box 
  • Selecting User defined range in Input box

  • Creating a User Form
  • Label, Text Box, Combo Box, List Box
  • Check Box  Option Button
  • Spin Button, Command Button
  • Frame

Using Excel Application and Function

  • Sorting and Filtering Data Using VBA
  • Creating Pivot Table Using VBA
  • Text to Column
  • Remove Duplicate
  • Formatting
  • Protecting/Unprotecting a Sheet Using VBA
  • Using Excel Formulas like V-lookup
  • H-lookup and other functions in VBA
  • Import Text/CSV files using VBA 

Outlook & PPT Automation

  • Connecting with Microsoft Outlook
  • Creating Outlook New Session
  • Early Binding and Late Binding
  • Formatting HTML and Plain/Rich Text Body
  • To, CC, BCC, Subject ,Body Text & Signature
  • Attach a file in Email using VBA
  • A Simple Programme of Email
  • Automate Multiple Mails