Macro VBA

Duration: 2 days

  • Configuring Excel for Macros

  • The Visual Basic Environment

  • Excel VBA Using the Macro Recorder

  • The Visual Basic Editor

  • Programming Concepts

  • VBA Variables and Data Types

  • Control and Decision Structures

  • Looping

  • Error handling

  • Debugging the Code

  • Using Ranges

  • Using Names

  • Workbooks and Worksheets Objects

  • Communicating with Your Users