Explore
  • Adobe
  • Autodesk
  • Bentley
  • Business
  • Education
  • Google
  • Human Resources
  • Microsoft
  • Retrieve Software Suites
  • Technical
  • Miscellaneous
  • Vectorworks
    • Cart

    You have no items in your shopping cart.

    • Home »
    • Microsoft »
    • Introduction to Excel 2010 VBA Macro Programming
    Introduction to Excel 2010 VBA Macro Programming

    • Introduction to Excel 2010 VBA Macro Programming

      $60.00
    $60.00

    Product Overview

    Introduction to Excel 2010 VBA Macro Programming

    Product Description

    This course introduces the user to Excel 2010 macro programming using Microsoft’s Visual Basic for Application (VBA). The overall focus of this course is to teach the user proper Visual Basic programming techniques along with an understanding of Excel’s object structure. Other topics in this course include; proper variable declaration, control structure use, looping, and Userform creation. The final section deals with the debugging tools included in the Microsoft VBA editor and methods on how to effectively use them.



    Table of Contents - Volume 1:



    • Introduction

    • Macro Development Basics

      • Overview

      • Displaying the Developer Tab

      • Setting Macro Trust within Excel 2010

      • Recording and Running a Macro

      • Examining the VBA Editor



    • VBA Programming Fundamentals

      • Overview

      • Reviewing the Excel Object Model

      • Understanding Functions and Procedures

      • Understanding Variables and Scope

      • Commenting your Code

      • Creating Constants

      • Using Functions within Excel

      • Understanding Arguments



    • Working with Control Structures

      • Overview

      • Using If/Then/Else Condition

      • Using a Select/Case Statement

      • Creating For/Next Loops

      • Using the Do Loop

      • Using the While/Wend Loop

      • Infinite Loops



    • Using VBA Functions


     


    Table of Contents - Volume 2:



    • Using VBA Functions

      • Overview

      • Using the Object Browser

      • Using the InputBox() Function

      • Understand the MsgBox() Function

      • Using String Functions

      • Using Date Functions



    • Creating UserForms

      • Overview

      • Designing a Form

      • Adding VBA Code to the UserForm

      • Closing the Form



    • Debugging Techniques

      • Overview

      • Understand the Difference Between Syntax and Logic Errors

      • Running a Macro Within the VBA Editor

      • Using Breakpoints

      • Creating a Watch

      • Adding Error Traps



    • Conclusion


     

    Related Content