How to Build a VBA App in Just 30 Minutes

Quick Start guide introducing lots of the VBA concepts required to build great apps
English
English [Auto]
VBA Excel and UI design
How to write readable code in VBA

Requirements

  • Must have Microsoft Excel - All versions supported

Description

Ever wanted to impress work colleagues with a user interface for your Excel documents? This free course walks you through the simple steps to achieve this.

Now is your chance to shortcut the long and tricky tutorials online, simply follow along with a basic worked example and learn how you can setup your own user interface form in Excel.

This course does not require any prior coding skills, you will need access to a computer running Microsoft Excel. You will also need to actually follow along and try out what you learn in order to get maximum value from this fantastic free course!

Craig has been working with Excel for well over a decade. He started out automating tasks for senior colleagues as a student using simple macro recorders, since that point he has never stopped using and learning what Excel can do to make his life easier.

A word of warning, although the course is delivered in 30 minutes, beginners will need to go back and re-watch the lessons presented in this course, as well as ask questions to the instructor – Craig. Learning a new skill is never easy, you didn’t learn to speak your native tongue in 30 minutes, and neither will you learn to code in 30 minutes- no matter how good the course is!

Who this course is for:

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

Course content

1 section12 lectures30m 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
  • 237 Reviews
  • 8,031 Students
  • 3 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.