- Creating a simple userform
- Custom Quick Launcher Button
- Create a Module and Sub
- Use Ctrl + Enter Autocomplete magic
- Use Form Events to Populate a Combo Box
- Writing a Function
- Globals
- While Loops
- Calling a Function from a Function
- Quick Review!
- Switch / Select Case Statements
- Finishing it all Off!
What you'll learn
- VBA Excel and UI design
- How to write readable code in VBA
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!
Other Courses

5 Keys To Investing
Learn the 5 key principles and become a better investor in stocks, bonds, mutual funds, ETF, real estate, and more!

Free Yin Yoga Level 1 Teacher Training
Certified Yin Yoga Teacher Training for aspiring Yin Yoga Teachers

CCNA MPLS Core technologies and MPLS Layer 3 VPNs: Exam prep
Prepare for CCNA, ICND2, CCNP or CCIE exams by learning about MPLS, VRFs, MBGP, Labels, redistribution, VPNV4, PHP +more

Python Crash Course: Learn Python Concepts Easy & Fast Way.
Python Crash Course: Learn Python Concepts Easy & Fast Way, so you will master Python Fundmentals effectively & simply.

Learn Basics of Project planning for Construction project
Gain Basic knowledge in project Planning , Project Scheduling & project Management With MS-Excel

Cool Cisco IOS commands. Master CLI tips = CLI like a Boss!
Time saving Cisco CLI tips and tricks. Configure the Cisco CLI like a CCIE. Save time, impress others with GNS3 & Cisco!
About the instructors

- 4 Calificación
- 9183 Estudiantes
- 3 Cursos
Craig Barry
UK Based Engineer
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.
Student feedback
Course Rating
Reviews
Simple approach
Not really enough information for others to lean on. Just bits and bites of stuff and skipping stuff. More focus was on purchasing his full class. This didn't convince me to purchase at all. In a hurry and leaves out content that would be of value before proceeding to next video. Waste of my time.
Thank you so much, you're amazing. I will go on to watch your more in-depth video to fully grasp Excel VBA. You really simplified the learning for me.
Good headstart for VBA