Microsoft® Excel VBA Level 2: Variables and Constants

Microsoft® Excel VBA: Variables and Constants will delve deeper into the core components of the Visual Basic language. The internal framework of code structure will be discussed, including objects, properties, and methods. The user will also be exposed to variable and constant declaration as well as the scope and lifetime of those variables. This course will also cover blanket methods for trapping program errors.

Objective: Upon completion of this course the user will effectively construct code blocks where explicit variables will be used to control user input values as well as define and use constant values in VBA procedures. Basic error-trapping techniques will also be explored.

  • Structuring VBA code
    1. Objects, Properties, and Methods
      1. The Offset Property
      2. Using Command buttons
  • Declaring Variables
    1. Data Types
    2. The DIM statement
    3. Scope and Lifetime
    4. Public and Private Modules
  • Declaring Constants
  • The InputBox function
    1. Returning variable values to a spreadsheet
  • Error Trapping
    1. The On Error statement
    2. Creating an error subroutine

Knowledge Source Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:

Course Information
  • Course Level:Advanced
  • Prerequisite:Microsoft® Excel VBA: Macros
  • Credit:2 CPE Hours
  • Fee:$99
  • Delivery:Virtual Instructor-Led Live
  • Recommend Field of StudyComputer Software and Applications
  • Program Knowledge LevelAdvanced
  • Advanced PreparationDownload and install class files a minimum of 3 working days prior to class.
  • Refund PolicyRequests for cancellations must be submitted in writing and received by Knowledge Source Inc. five (5) days prior to the date of the event to receive a full refund (less a 10% processing fee). Refunds are not given for no-shows. Special circumstances and cancellation requests may be emailed to or by calling 919-878-7100. Refunds will be issued within 30 days after the course.

Related Courses