VBA course content -

• Introduction to VBA
• Connection in Excel & VBA
• Role to the Developer tab
• Learn VBA Editor Tools and windows
  • Front facing of VBA Editor
  • Project Explorer understanding
  • Properties window
  • Debug toolbar
  • Local window
  • Watch window

 

• Basic funda of VBA programming
  • Introduction to Variables
  • Scope of Variables
  • VBA Procedures
  • References
  • Relational & Logical Operators
  • Learn selection up-down, right-left movement with excel cells
  • Letâ??s start with your first program

 

• Decision making a conditional statement and controlling program related essential element
  • If statements
  • Case statements
  • Code improvisation using loops like For-Next loop, Do-While loop, Do-Until Loop
  • Using loops with multi-dimensional arrays
  • Programming Tasks related to this module.

 

• Event class â??
  • Know the role of the event on automation
  • Explanation with practical examples of several Events of workbook and worksheets
  • Event handling programs
  • Programming Tasks related to this module.

 

• Error Handling techniques â??

 

• Introduction to User-Form controls -
  • Understanding on Various user form tools
  • User form techniques
  • Live practical use of UF tools (Combo box, list box, Options button, etc)
  • Programming Tasks related to this module