How to Build a VBA App in Just 30 Minutes

Quick Start guide introducing lots of the VBA concepts required to build great apps
Rating: 4.2 out of 5 (172 ratings)
5,462 students
English
English [Auto]
VBA Excel and UI design
How to write readable code in VBA

Requirements

  • Must have Microsoft Excel - All versions supported

Description

Follow along with this free compact course and learn how to write a completely working app in VBA in no time at all.  As you learn with me, you will be build an app that can apply a filter to some dummy data.  Check it out and improve your VBA skills.

Who this course is for:

  • Beginners and Intermediate Excel users looking to learn VBA to automate their workflow

Course content

1 section • 12 lectures • 30m total length
  • Creating a simple userform
    02:37
  • Custom Quick Launcher Button
    02:21
  • Create a Module and Sub
    01:14
  • Use Ctrl + Enter Autocomplete magic
    01:02
  • Use Form Events to Populate a Combo Box
    03:37
  • Writing a Function
    01:39
  • Globals
    01:44
  • While Loops
    05:44
  • Calling a Function from a Function
    03:13
  • Quick Review!
    01:15
  • Switch / Select Case Statements
    04:00
  • Finishing it all Off!
    02:24

Instructor

UK Based Engineer
Craig Barry
  • 4.2 Instructor Rating
  • 176 Reviews
  • 6,785 Students
  • 2 Courses

Craig holds a masters degree in automotive engineering with a keen passion for writing and teaching how to write software. He currently works for a small engineering consultancy based in Cambridge England.

An innovative engineer drawing on 10 years of commercial experience, Craig uses Excel to manage and analyse huge datasets from vehicle emissions testing. He has mentored various people through the years and has decided to combine all that knowledge in course format.

Craig is excited to share his Excel skills and knowledge with students across the world. Come and learn to use Excel professionally by enrolling on the course.