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 CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js 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 Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing 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
Office Productivity Microsoft Excel VBA

Visual Basic for Excel - Microsoft VBA Excel Tutorial

Master Visual Basic for Excel, learn to unlock the true power of Excel. Tutorial Taught by a leading Microsoft Expert
Rating: 4.3 out of 54.3 (1,636 ratings)
13,788 students
Created by Infinite Skills
Last updated 1/2017
English
English
30-Day Money-Back Guarantee

Description

A Verifiable Certificate of Completion is presented to all students who undertake this course.

In this Visual Basic for Excel training course, you will learn how to apply the VBA programming language to make your Excel spreadsheets much more powerful. This course starts you out with the basics of VB programming, and teaches you to use it to its fullest potential within Excel.

The tutorial extends your knowledge past editing odd Macro, directly into creating custom scripts using the VBA Programming Language. This Visual Basic for Excel tutorial will teach you about VBA structures, the difference between Functions and Subroutines, how to manipulate Excel Cells, interacting with the user and very importantly, error handling. Designed for the beginner, you do not have to be a programmer already to understand, and implement what you will learn in this software training course.

By the conclusion of this Visual Basic for Excel training course, you will be familiar with the VBA programming language, as it applies to Microsoft Excel. You will be able to apply this knowledge to make interactive and fully functional spreadsheets. Working files are included to let you work alongside the author as you learn Visual Basic for Microsoft Excel in this video tutorial.

Course content

12 sections • 90 lectures • 8h 6m total length

  • Preview00:01
  • Preview03:56
  • Preview03:00
  • Preview05:07
  • Excel 2010 Security Settings And Macro Files
    03:44
  • The Developer Ribbon
    01:54

  • Recording And Running A Simple Macro
    03:51
  • Editing An Existing Macro In The Visual Basic Editor
    03:59
  • The New Macro Enabled File Type
    02:22
  • Quick Tour Of The Excel Visual Basic Editor
    06:00
  • Watch A Macro Write Your VBA
    02:58

  • What Is A Module?
    03:19
  • Creating A Sub Procedure Manually
    03:14
  • How To Call A Sub Procedure
    02:49
  • Creating A Function Procedure
    02:51
  • How To Call A Function
    02:57

  • Using Comments Within Your VBA Code
    03:58
  • Declaring Variables And Data Types
    05:29
  • The Scope Of A Variable
    04:49
  • The Static Declaration And Variable Expiry
    04:53
  • Constants Instead Of Variables
    03:39
  • An Intrinsic Constant
    03:07
  • String And Date Types Expanded
    06:04
  • Excel VBA Operators
    07:50
  • Arrays
    05:07
  • Multi-Dimensional Arrays
    03:32
  • Dynamic Arrays
    03:22

  • Referencing Cells Using The Range Object
    05:28
  • The CELLS Property
    02:46
  • The OFFSET Property
    02:29
  • The VALUE Of Ranges
    07:43
  • The TEXT Object Of The RANGE
    03:01
  • A Number Of Read Only RANGE Properties
    09:06
  • The FONT Property And Colors
    08:20
  • Formatting Numeric Values
    03:24
  • Add Formulas To Cells Through VBA Code
    06:36
  • Common METHODS Of The RANGE Object
    11:46

  • What Is A Function?
    01:30
  • Built In VBA Date Functions
    02:29
  • Text Manipulation With VBA Functions
    03:53
  • Determining File Sizes Using FILELEN
    02:34
  • Using Worksheet Excel Functions In VBA Code
    08:09
  • User Defined Functions In Excel
    04:35

  • Using GOTO And Labels
    04:25
  • Controlling The Program Flow With IF THEN ELSE
    04:23
  • Multiple Criteria Plus Nested IFs
    05:27
  • Adding ELSEIF To Speed Up Execution
    04:07
  • SELECT CASE As An Alternative To IF
    04:24
  • The FOR NEXT Loop
    09:25
  • FOR NEXT With A VBA Collection
    06:32
  • DO WHILE Loop
    06:56

  • How To Create An Event
    06:57
  • WorkBook Events - Open
    08:17
  • Workbook Events - Closing And Saving
    07:32
  • Workbook Triggers - Activate And Deactivate
    05:12
  • Worksheet Triggers - Activate And Deactivate
    04:15
  • Other Useful Worksheet Triggers
    09:44
  • Using Application Events
    12:06

  • Error Trapping the Easy Way
    07:38
  • Make The VBA Ignore Errors
    04:12
  • Interact With The User When An Error Occurs
    04:58
  • Making Use Of The ERR Object
    04:14
  • Debugging Techniques
    06:11
  • Using Breakpoints To Help Debug
    05:45
  • Setup And Use A Watch
    05:04
  • Speeding Up The VBA Tips
    12:50

  • Using MSGBOX To Interact With Users
    09:05
  • Use INPUTBOX For Accepting Values From Users
    07:19
  • Selecting A Range With The INPUT Box
    04:05
  • An Introduction To UserForms
    04:06
  • Creating A UserForm
    04:22
  • Using Command Buttons In Excel
    05:17
  • Adding Option Buttons In A Frame
    05:12
  • Adding The Code That Makes The Form Work
    07:17
  • Calling Your UserForm And Validating Content
    08:05
  • UserForm Controls - The CheckBox
    08:10
  • UserForm Controls - ListBox And/Or Combo Box
    10:10
  • Images On UserForms
    05:24
  • Labels And Text Boxes
    05:30
  • Multiple Tabs On A UserForm
    08:10
  • Allowing The User To Highlight A Range
    04:13
  • Scrollbar And Spin Controls
    08:18
  • Controlling Tab Order And Aligning Controls
    08:48

Instructor

Infinite Skills
High Quality Training
Infinite Skills
  • 4.3 Instructor Rating
  • 117,538 Reviews
  • 1,233,255 Students
  • 327 Courses

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

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