- 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
How To Be Happy Reaping What You Sow - Get Real Success
The World Has Deceive You From Being Happy, Learn The Secrets To Finally Achieve Happiness & Goals In Your Life Today
Intel Edison Step by Step - Part I
In this course you will learn how to use Intel Edison for the first time and Flex sensor with different hardware.
NCM: Learn Chinese Common Mistakes and Useful Tips
To help you avoid common mistakes and provide useful tips on learning Chinese
Install Wordpress Locally & Move Website Online
Learn how to install wordpress on computer using free software called WAMP Server. Build Websites and Blogs Free.
SEO Driven Content Marketing For Entrepreneurs & Startups
Learn how to build & launch an SEO driven content marketing strategy from scratch in 90 minutes and 10x your traffic!
About the instructors
- 4.35 Calificación
- 11968 Estudiantes
- 1 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
This is showing me exactly what I was looking for
Good briefing. Thanks
Un peu brouillon mais productif
Nice
Good examples especially for users with some experience.
Its a bit confusing a lot of jumping around, but I gues that's what you get with free courses