Excel VBA and Macros User Forms

Learn to create Awesome excel VBA Userforms

3.60 (40 reviews)

Udemy

platform

English

language

Programming Languages

What you will learn

At the end of this course, students will be able to create advance userforms in Excel

Why take this course?

Hello everyone! It's your instructor here :)

Let me ask you!

Are you one of those who hates how data entry is done in Excel ?

Then Excel VBA Userform is your answer. In Excel VBA, userform not only allow you to create awesome sheets but also makes data entry more secure and efficient. Also, you can create very beautiful looking animations, play music and so on with Userform.

This course aims to teach you the techniques and skills that you need to create awesome looking Userforms and will help you in converting your boring Excel spreadsheet into awesome user-friendly interface.

We'll start off by understanding the VBE (Visual Basic Environment).

Get an overview of all that's present on the interface such as settings, controls, properties and much more.

Once done, we'll look at controls such as Command Button, Label, Picture and some more.

Then we'll head off towards creating basic animation in our userform

Lastly, we'll create our final project.

It's going to be a data entry project which contains controls for, adding, deleting and editing our entry in our excel sheet.

All the best guys! I hope you have amazing time learning this skill and have booming future career.

See you inside :)

Screenshots

Excel VBA and Macros User Forms - Screenshot_01

Excel VBA and Macros User Forms - Screenshot_02

Excel VBA and Macros User Forms - Screenshot_03

Excel VBA and Macros User Forms - Screenshot_04

Reviews

Harshita

May 11, 2020

Lot of basic knowledge is assumed. I only learnt one possibility of user forms. to manage employee list but I dont do that job The course must be renamed as "introduction to Excel user forms" or ABCs of user forms because thats all that it is!!

Grant

December 1, 2018

Best of the lot thus far... This course however, has been the most applicable and complete User Form Project that includes save, cancel and edit, let alone picture association lessons... quickly and succinctly... My one critique would be that a final download will help to isolate and resolve finger errors like when you typed the variable "Password" incorrectly in one of your final project lessons, i.e. we all make them... but while you, the teacher finds it easy to locate, we students don't and it will lead to course interest paralysis... Still, if nothing else, resolving our own errors etc helps us learn quicker if we are resilient and patient... (I speak for myself)

Barend

September 3, 2018

Instructor did well overall. Speaking critically only.....would have liked to see more written explanations within the code and perhaps what it's expected to execute to tie the project together better. A bit scattered at times, jumps around too much taking your focus away of what the current lecture is actually trying to accomplish. Each lecture felt rushed, making it challenging to absorb the material adequately which is the whole point. Another completed real world example file would have been very beneficial. Could you send me another completed example real world example Userform? Overall, it was good ! Thanks

Pierre

June 10, 2018

Jumping in Userform without any 1st proper introduction. The course is called VBA and macros. At the moment it doesn't make sense

Falgesh

May 25, 2018

Yes, good start to understand the concept, nevertheless it is for beginner. I was more keen to learn, perhaps may come in subsequent presentation, about how to take user input, put it in variable, and pass it on to other modeul/procedure which macro executes.

Ameer

July 13, 2017

A very good edification about the Command , lables , texts buttons ..& Entire user form and search & and edit details

Rob

June 7, 2017

The peace of speech was fast. Some novice users may not follow his logic because they are trying hard to understand what he is saying. Other than that it was a good overview for user forms in Excel.