How to Build a VBA App in Just 30 Minutes

How to Build a VBA App in Just 30 Minutes, available at Free, has an average rating of 4.35, with 12 lectures, based on 395 reviews, and has 11051 subscribers.

You will learn about VBA Excel and UI design How to write readable code in VBA This course is ideal for individuals who are Beginners and Intermediate Excel users looking to learn VBA to automate their workflow It is particularly useful for Beginners and Intermediate Excel users looking to learn VBA to automate their workflow.

Enroll now: How to Build a VBA App in Just 30 Minutes

Summary

Title: How to Build a VBA App in Just 30 Minutes

Price: Free

Average Rating: 4.35

Number of Lectures: 12

Number of Published Lectures: 12

Number of Curriculum Items: 12

Number of Published Curriculum Objects: 12

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

VBA Excel and UI design

How to write readable code in VBA

Who Should Attend

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

Target Audiences

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

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!

Course Curriculum

Chapter 1: Welcome to My Quick Start Guide to VBA in Excel

Lecture 1: Creating a simple userform

Lecture 2: Custom Quick Launcher Button

Lecture 3: Create a Module and Sub

Lecture 4: Use Ctrl + Enter Autocomplete magic

Lecture 5: Use Form Events to Populate a Combo Box

Lecture 6: Writing a Function

Lecture 7: Globals

Lecture 8: While Loops

Lecture 9: Calling a Function from a Function

Lecture 10: Quick Review!

Lecture 11: Switch / Select Case Statements

Lecture 12: Finishing it all Off!

Instructors

Craig Barry
UK Based Engineer

Rating Distribution

1 stars: 21 votes

2 stars: 17 votes

3 stars: 67 votes

4 stars: 125 votes

5 stars: 165 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!