Excel VBA Programming - Intermediate
IC0977

Excel VBA Programming - Intermediate

You are ready for this course if you have completed a beginner course in Visual Basic Programming for Applications (VBA) – or you’ve used VBA in your personal life or at work. Challenge yourself with the next logical step! Intermediate VBA steps you through a series of more powerful, more advanced features of VBA programming that can be used even in other Office applications. Includes downloadable exercise files and solutions.

1  Reviews   5.0 of 5.0

Course Goal

  • Learn advanced methods for automating tedious Excel jobs
  • Understand how to write and implement Excel events
  • Learn how to design and implement specialized classes of objects
  • Discover how to customize the right click menu within cell ranges

Audience

  • Consultants
  • End users
  • IT/Business analysts
  • Project Managers
  • Project team members

Exam/Certificate


Lesson Plan

2
Chapter 2 Preview
3
Excel File Types
4
Code Modules
5
Detailed Memory Management
6
Code Module Interactions
7
The VBA Project Model
8
Advanced Parameter Definitions

9
What Are Events?
10
Pre-Defined Events
11
Event Parameters
12
A Series Of Example Events
13
Application Events

14
Chapter Overview + New Keyword
15
Creating A Custom Type
16
Create a New Class
17
Defining a Class
18
Practical Example of a Class
19
Practice Test of a Class
20
Special Class Variables and Components
21
Initialization and Termination
22
VBA Attributes and Usage
23
Inheritance - Defining the Bookmarks Support Class
24
Creating a Userform
25
Designing a Userform
26
Coding a Userform

27
Modifying the Excel Interface
28
UI Interface Scope and Range
29
UI Interface Control Options and Access
30
UI Callbacks
31
UI Modifications and how to apply them

32
What are References? How do they work?
33
Reference Object
34
Office Libraries
35
ADODB Library
36
The Scripting Library

37
Course Conclusion
38
Download - Topic Exercise Files and Solution Files

Instructor

Simon Calder

4.8 Average Rating

4 Reviews

49 Students

5 Courses

Simon Calder

President

Simon Sez IT makes business and technical software simple to learn. We teach people to use the most popular business software including Microsoft Office, Microsoft Project, Photoshop, Web Design and QuickBooks. We've been teaching online for over ten years.

It all started when the owner, Chris "Simon" Calder was working as a Project Manager in IT for one of Los Angeles most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course which he sold on DVD via eBay. Fast forward to now and Simon Sez IT has taught hundreds of thousands of students through its online course platform and popular YouTube channel.


More Courses by Simon Calder:

Complete Excel 2019 for Beginners
Complete Excel 2019 for Beginners

This Excel course is perfect for those who are new to Excel and who are using Excel 2019 or Excel 365 editions. In th...

5.0

Average Rating

Excel 2019 Advanced
Excel 2019 Advanced

Move your knowledge beyond the basics and supercharge your Excel capabilities. With this 8-hour, expert-led video tra...

5.0

Average Rating

Excel 2016 Intermediate
Excel 2016 Intermediate

This course takes you well beyond the beginner stage to become an Excel power user. Learn the additional advanced ski...

New Course - Not Enough Reviews yet

View All Courses

Student Feedback

5.0

Average Rating

Reviews

Annual Subscription to All Courses
$1599

Or subscribe to this course for

$189


Training 5 or more people?

Unlimited access for your entire SAP team including admin platform and premium reporting.

SAP Training for Businesses

Language: English
Level: Expert
Duration: 4.00 hours
Type:  Instructor-led
Release: Enterprise Software
Category: Business Productivity

SAP students

142

student views.
Join them!


Related Courses