Description

Learn VBA from the beginning steps to seeing how a maintenance application (one that runs every week or month) could be built, step by step. You will learn how to record and edit macros, get information from a user, create and use Userforms, various ways to do loops, if-then-else constructs, Select Case, Using variables, Function subroutines, and much more.

Course Objectives

To allow the user to make repetitive tasks be solved more easily; to create one's own personal set of tasks which will always be available. After this class you'll be well on your way to becoming a programmer.

Target Audience: People with a basic knowledge of Excel to advanced users. This course does start from the very beginning

Target Audience

People with a basic knowledge of Excel to advanced users. This course does start from the very beginning

Basic Understanding

Able to use Excel 

Course Content

No sessions available.

Simpliv Logo
Simpliv LLC
39658 Mission Boulevard,
Fremont, CA 94539, USA

2 Days Live Virtual Training on Excel Macros & VBA Programming

Session 1: Features

  1. Recording macros
  2. Editing macros
  3. Getting a message to/from the user
  4. Learning the environment (VBE)

    Module pane 

    Immediate window 

    Project Window 

    Properties Window 

    VBA Toolbars 

Session 2: Learning all about the most important object, the “Range” object

  1. Cells
  2. Offset
  3. Resize
  4. Directions
  5. Union
  6. Intersection
  7. Virtual worksheet
  8. Current Region
  9. Used Range
  10. Visible Range
  11. Special cells
  12. Areas

Session 3: VBA Constructs

  1. If-then-else-End if
  2. Case-End Case
  3. And/Or

Session 4: Loops

  1. For/Next
  2. Do/Until
  3. Do/While
  4. While/Wend
  5. Do/Loop

Session 5: Scope of Variables (how long do they “live”?)

No lectures available

Session 6: Creating a mini-application

  1. Add records to a list by VBA

    Checking for errors

Session 7: User-defined Functions

No lectures available

Session 8: Event programming

  1. Taking action when:

    A selection changes 

    The worksheet is calculated 

    A sheet is activated/deactivated 

    Before a doubleclick 

    Before a right-click

Session 9: Creating and using Userforms

No lectures available

Session 10: Walking through a monthly maintenance application

  1. Creating it step-by-step

Coupons

No offers available at this time.

Live Support

Call

+510-849-6155

Mail to

support@simplivlearning.com

Similar Courses

Our Trusted Clients