How to Build a VBA App in Just 30 Minutes
- Must have Microsoft Excel - All versions supported
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
- 02:37Creating a simple userform
- 02:21Custom Quick Launcher Button
- 01:14Create a Module and Sub
- 01:02Use Ctrl + Enter Autocomplete magic
- 03:37Use Form Events to Populate a Combo Box
- 01:39Writing a Function
- 05:44While Loops
- 03:13Calling a Function from a Function
- 01:15Quick Review!
- 04:00Switch / Select Case Statements
- 02:24Finishing it all Off!
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.