Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication 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 Certifications Network & Security Hardware Operating Systems & Servers 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 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 Paid 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 & Gardening 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 & Diet Yoga Mental Health Martial Arts & 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 Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js HTML5 PHP Vue JS
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA Microsoft AZ-900 AWS Certified Developer - Associate
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Qlik Sense Blockchain
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Virtual Reality
Google Flutter Android Development iOS Development React Native Swift Dart (programming language) Mobile App Development Kotlin SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting Canva InDesign Character Design Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Meditation CBT Cognitive Behavioral Therapy Sound Therapy
Entrepreneurship Fundamentals Business Fundamentals Freelancing Business Strategy Startup Business Plan Online Business Blogging Home Business
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Google Analytics Copywriting Email Marketing YouTube Marketing Podcasting

Office ProductivityMicrosoftExcel VBA

A beginner’s and intermediate guide to VBA programming

Learn how to unlock the power of Microsoft's VBA programming language to build effective and powerful programs.
Rating: 3.8 out of 53.8 (68 ratings)
1,812 students
Created by Francois Barnard
Last updated 6/2014
English
English [Auto]

What you'll learn

  • By the end of this course you will be able to design and develop your own custom programs
  • In this course you will learn how to control program flow through VBA statements
  • In this course you will learn how to develop custom Excel objects
  • In this course you will learn how to develop functional programs and sub procedures
  • In this course you will learn to how access standard Excel objects from within the VBA editor using the Object browser
  • In this course you will learn to how add error handling capabilities to your programs

Requirements

  • A copy of Microsoft Excel
  • Time and patience to work through the course
  • Basic problem solving skills

Description

Have you ever felt frustrated using Microsoft Excel to perform mundane and often repetitive tasks? Have you ever felt that there has to be an easier and faster way to perform to do something? Well, using Microsoft Visual Basic for Application (VBA) programming language allows you to automate manual tasks within Excel and allows you to be more effective and efficient with your time. Not only does it provide you access to a rich library of additional tools and capabilities, over and above what a standard user may have access to, it can also be used to integrate with some of the Microsoft other Office applications such as Outlook, Word and MS Access.

  • So, who should take this course?
  • Anyone who wants to learn how to be a proficient VBA programming

Anyone who wants to learn how to effectively utilize the tool to solve and automated manual tasks

In this course you will learn some of the fundamental concepts of the VBA programming language. Not only does this course include a review of the basic concepts and key functionality available within this rich programming language such as the IF, Select Case and Loop Statements, you will also learn how to design and develop your own custom objects using the concepts of object orientated programming through the use of class modules.

This course starts off with a brief refresher on the basic concepts of the VBA programming language and a review of the VBA Editor, the development environment that we will use during this course.

This program also includes a number of practical examples, to help demonstrate how to effectively utilize the concepts that you have covered during this course. This course includes the key concepts and practical examples of the following VBA statements and functionality:

  1. IF Statements
  2. Loop Statements (For Next, Do While, Do Until)
  3. Exit Statements
  4. Goto Statements
  5. Select Case Statements
  6. Enumeration Data Types
  7. The DoEvents Statement
  8. Macros
  9. Arrays (declaring, re-initializing, auto populating and deleting arrays)
  10. Error Handling
  11. Standard Excel Objects
  12. Functions and Procedures
  13. Passing Values To Functions By Value
  14. Passing Variables to Functions By Reference
  15. Advance String Manipulation using the Trim, LTrim, RTrim, Left, Right, Instr and InstrRev Statements
  16. User forms
  17. Classes / Custom Objects
  18. Variable Declaration And Scope

We finish the training course by reviewing additional practical examples of how to apply the key concepts that we have reviewed during this course. In total, this course provides approximately 9 hours of course videos, including practical files and examples to help you become a proficient and effective programming.

Who this course is for:

  • Students
  • Beginner to intermediate programmers
  • Users looking to automate frustrating and time consuming tasks
  • Expiring programmers
  • Someone looking to build upon previous experiences and exposure to VBA

Instructor

Francois Barnard
Information Technology Consultant
Francois Barnard
  • 3.8 Instructor Rating
  • 68 Reviews
  • 1,812 Students
  • 1 Course

I have always been very passionate about computers and technology in general after receiving my first 8086 Olivetti computer in the late 80’s. I still recall the day that that Double Tools for DoubleSpace was released, which allowed you to backup 2.8 mb on a 1.44 mb disk. Back then I thought that was the ultimate technological breakthrough. However, needless to say, I think we have progressed well beyond that.

I graduated from University with a BCom and Honors in Accounting and promptly went to work for one of the big public accounting firms, where I also managed to achieve my chartered accountant designation. Even though I started in accounting I have always wanted to work in technology and was fortunate enough to be introduced to programming and relational database design early on my career, developing decision support and financial models for clients using MS Access and Microsoft Excel. My experiences with these tools and programming in general have taught me the value of good coding practices and I have come to believe that you always have to assume that no matter how small a project, it can always grow and expand well beyond your original scope. Now, I always design and build programs as if I am going to have to support them for years to come.

I also have an extensive technical background and work experience in Information Security, data analytics and data mining and currently work for a large national consulting firm, located in Northern Virginia.

Other programming languages that I have experience with in addition to VB and VBA are Objective C, C++ and C#.

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.