Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Neuroscience Coaching
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 4 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Excel VBA

Excel 2007 VBA

Power up your workbooks with Visual Basic for Applications automation
Rating: 4.4 out of 54.4 (22 ratings)
192 students
Created by Intellezy Trainers
Published 4/2013
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Understand the object model
  • Create, edit and run recorded macros
  • Understand the Visual Basic editor
  • Understand programming basics
  • Use Visual Basic functions
  • Create and use cotnrol structures
  • Create, use and edit UserForms
  • Debug macros and trap for errors

Requirements

  • Intermediate Microsoft Excel training or equivalent experience

Description

This course introduces you to Excel macro programming using Microsoft's Visual Basic for Application (VBA). The overall focus of this course is to teach you proper Visual Basic programming techniques along with an understanding of Excel's object structure. Other topics in this course include; recording macros, programming basics, proper variable declaration, Visual Basic functions, control structure use, looping, and Userform creation. The final section deals with the debugging tools included in the Microsoft VBA editor and methods on how to effectively use them.

Who this course is for:

  • Intermediate and Advanced level users of Excel who need to automate worksheets and workbooks

Course content

10 sections • 47 lectures • 4h 14m total length

  • Preview02:43

  • Preview01:50
  • Preview03:07

  • Preview02:10
  • Preview01:58
  • Recording a Macro
    06:40
  • Running a Macro
    00:40
  • Editing a Macro with the Visual Basic Editor
    03:03

  • Examining the VBA Editor Menu and Toolbar
    09:43
  • Setting VBA Editor Options
    08:52
  • Reviewing the Project Explorer
    01:14
  • Reviewing the Properties Window
    03:04
  • Understanding the Object and Procedure drop-down lists
    01:16
  • Viewing the Immediate Window
    02:36
  • Viewing the Object Browser
    05:36

  • Preview05:53
  • Dimensioning Variable
    12:27
  • Understanding Object Variables
    05:10
  • Understanding Variables and Scope
    05:44
  • Commenting your Code
    04:53
  • Creating Constants
    04:28
  • Manipulating Data
    06:33
  • Understanding Procedure Arguments
    09:42

  • Using the InputBox() Function
    11:22
  • Understanding the MsgBox() Function
    10:02
  • Using String Functions
    12:07
  • Using Date Functions
    11:08

  • Using If/Then/Else
    06:41
  • Creating a Select/Case Statement
    05:02
  • Understanding Logical Operators
    04:30
  • Creating For/Next Loops
    06:58
  • Creating Do Loops
    06:20
  • Creating While/Wend Loops
    05:00

  • Preview01:09
  • Understanding Controls
    11:28
  • Setting Control Properties
    01:06
  • Referencing Controls in VBA Code
    02:44
  • Responding to Events
    11:16
  • Creating a function to open a UserForm
    02:19
  • Development Tips
    02:59

  • Preview04:22
  • Running your Macro from the VBA Editor
    01:01
  • Setting Breakpoints
    01:35
  • Stepping Through Your Macro
    03:44
  • Creating Watches
    06:58
  • Adding Error Trapping
    11:24

  • Conclusion
    03:25

Instructor

Intellezy Trainers
Computer Training Specialists
Intellezy Trainers
  • 4.4 Instructor Rating
  • 41,193 Reviews
  • 156,021 Students
  • 222 Courses

Intellezy collaborates with organizations to help implement and adopt technology to its maximum potential. From our change management consulting to our learning and development services, Intellezy uses both culture and education to drive the ROI of any organization. Our online videos and quick reference guides are designed to educate and empower individuals, right when they need it. In today’s rapidly evolving workplace, it is imperative to make sure you have the skills and expertise required to succeed. Our library, recognized by top influencers such as eLearning Journal and The Craig Weiss Group, provides dynamic and task-focused videos right at your fingertips, right when you need them.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.