Discover Classes. Earn 10% Rewards.

Excel VBA Macros: Write Custom Excel Macros in VBA is unfortunately unavailable

Thankfully we have 3 other All Software Classes for you to choose from. Check our top choices below or see all classes for more options.

Adobe Illustrator: Training for Everyone

Los Angeles City College See all classes by this school @ 855 N Vermont Ave, Los Angeles, CA

Build your skills in vector graphics and distinctive illustration design using Adobe Illustrator. Get hands-on with painterly brushes, shape-building utilities, path controls, transparency, and gradients across mediums while shaping personalized logos and business cards at Los Angeles City College's hands-on lab.

(935) Beginner 18 and older
$99

2 sessions

Attend
+990 pts
Gift it!

Digital Video Editing with Adobe Premiere Pro (Level 2)

Los Angeles City College See all classes by this school @ 855 N Vermont Ave, Los Angeles, CA

Push your video editing skills further with this intermediate Adobe Premiere Pro course. Step into advanced tools and techniques, including timeline pancaking, media browsing, and working with different resolutions. Build color correction, adjustment layers, and exporting settings for YouTube and Vimeo. The course is built for those already familiar with basic editing and project setup in Premiere Pro.

(935) Intermediate 18 and older
$199

3 sessions

Attend
+1990 pts
Gift it!

Adobe Photoshop: Training for Everyone

Los Angeles City College See all classes by this school @ 855 N Vermont Ave, Los Angeles, CA

Pick up essential concepts and advanced features of Adobe Photoshop in this thorough training course. Develop your graphic design, photo manipulation, and image restoration abilities, and create striking movie posters and pop art pieces. Stand apart from the crowd with strong design and imaging skills.

(935) Beginner 18 and older
$99

2 sessions

Attend
+990 pts
Gift it!
See all All Software classes Los Angeles

Excel VBA Macros: Write Custom Excel Macros in VBA

  • All levels
  • 16 and older
  • Earn 10% Rewards
  • Price Lock

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • 200 Pine Ave, Long Beach, CA
  • 14 hours over 2 sessions

Start Dates (0) $895/person

No upcoming dates are currently available.

Book a Private Group Event

Booking this class for a group? Find great private group events

Or see all Excel Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

Class Description

Description

Learn to create automated custom Excel applications using VBA. This two-day VBA Programming course helps advanced Excel users (Windows only) develop new skills writing and debugging powerful VBA code to automate workbook operations, create interactive forms, insert calculations and handle run-time errors.

Prerequisites:

This class is ideally suited for experienced Excel users who want to learn how to write programming code using Visual Basic for Applications.


Outline:

VBA Concepts

  • The Object Model Hierarchy
  • Understanding Properties, Methods and Events

Getting Started with VBA

  • Macro Security Options
  • Using the Macro Recorder

Editing Macros

  • Essential VB Editor Components
  • VB Toolbars
  • Using the Object Browser
  • VBA Module and Procedure Types
  • Writing Solid Code

Debugging Macros

  • Types of Programming Errors
  • VBE Debugging Tools
  • Stepping Through Code
  • Break Mode and Breakpoints
  • Watch Expressions
  • The Immediate window and Locals window

Assigning Macros

  • To the Toolbar
  • To the Ribbon
  • To Buttons

Using Variables

  • VBA Data Types
  • Declaring Variables
  • Scope of Variables

Refund Policy

  • You may cancel or reschedule a class registration at least 8 business days prior to the class without incurring any penalty.
  • After 8 business days, we may charge a penalty of up to 100% of the registration cost.
In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.

Reviews of Classes at Accelerate Computer Training (33)

(4.9-star rating across 33 reviews)

This class: 5.0 out of 5 from 1 review

  • Excel VBA Macros: Write Custom Excel Macros in VBA

    The instructor is very knowledgeable and ensures that you understand the material.
See reviews for other classes at Accelerate Computer Training
loading...
Hide Reviews

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 8950 points. Earn 10% back in reward points!

Accelerate Computer Training

Accelerate Computer Training offers hands-on computer training classes in Long Beach, California. Their experienced trainers provide personalized instruction in a variety of software applications, allowing students to improve their skills and enhance their work efficiency.

View school profile
Accelerate Computer Training
Vetted by CourseHorse

A verified Los Angeles educator.

Loading...