CPE Online Course Detail

Visual Basic for Applications in Excel 2007

Price :   $27.95
CPE Credits :   3.0
Course Code :   S009-0225
Category :   Computer Software

This training is designed as an introductory course to Visual Basic for Applications (VBA) for Excel 2007. You will learn what VBA is, and how it is used in Excel to create programs that will enhance your daily grind. You will learn how to write the code to create a calculator, how to add new worksheets to a workbook that duplicates an existing worksheet, and you will learn how to create a time logging application (DayLogger) that allows you to start and end time as you work on a client's job, and then calculates the time spent and logs it to a spreadsheet.

Delivery Method: Online Self Study

Level: Overview

Prerequisites: None

Advanced Preparation: None

Policies: Click here

Author: Jay R. Carlson

Category: Computer Software

Field of Study: NA

Passing Score: 70%

Publication Date: 01/13/2009

For More Detail: Click here

Module 1: Introduction to VBA
1. Enable VBA within Excel.
2. Use the Code Window to write code.
3. Run the program you created.
4. Stop (reset) the program.
5. Add a variable to the program code.
6. Build a form.
7. Add controls to the form.
8. Add code to the command buttons.
9. Save the program.

For More Objectives: Click here


QAS: Yes

CPA: Suitable for all CPAs

IRS: Enrolled Agents Program Number

© 2016 MasterCPE LLC
7683 SE 27th St., #216
Mercer Island, WA 98040


Continuing Education for Smart Professionals