Create your own App in Excel

Simple, easy step by step approach to creating your own applications using UserForms in Excel
4.3 (11 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
363 students enrolled
$20
Take This Course
  • Lectures 15
  • Contents Video: 1.5 hours
  • Skill Level Expert Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 1/2014 English

Course Description

UserForms is an advanced and powerful feature in Excel that allows for automation through the creation of Excel macros using VBA (Visual Basic for Applications). Userforms are custom forms that you can create to complement and interact with your worksheet, in some cases your userforms can completely replace interaction with your worksheet.

With userforms you can create custom forms with fields where input values can be selected from a dropdown, or checkboxes, create command buttons etc. Such forms can be created for those who are not comfortable working on an Excel sheet thereby making their interaction with excel to the bare minimum.

In this course, we take you through the various components that can be included in a custom form and most importantly we cover the various steps whereby you can ensure that data entered is always validated.

Needless to say to take this course you need a good working knowledge of Excel and VBA macros. If you would like to brush up your Basic Excel and VBA skills you can take our course on Excel for Beginners to Intermediate and our Excel Automation course.

What are the requirements?

  • Any versions of Excel from 2003
  • Knowledge of VBA in Excel

What am I going to get from this course?

  • To be able to create an interactive frontend linked to a database with the help of userforms

What is the target audience?

  • Inidividuals who have a good working knowledge of Excel & VBA
  • Those who would like to create a easy to use front end as an alternative to working on excel worksheets.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to Excel Apps using Userforms
01:30

Introduction to Excel Apps using userforms: Why userforms

In what ways are the userforms being used and in what ways can we use them

Please download supplementary material

01:49

Introduction to Excel Apps using userforms: Snapshot of the course

This lecture, gives a gist of all the topics covered in the course and intended outcome of the course.

Please download supplementary material

Section 2: Step By Step Approach to creating an App in Excel
01:11

Step by step approach to creating an App in Excel: Creating an Empty userform

In this lecture, we talk about how we insert an empty userform in VBA

Please download supplementary material

07:10

Step by step approach to creating userforms: Creating Controls

Here we talk about Controls like - Buttons, Text box, checkbox, radio button, dropdown, etc

08:18

Step by step approach to creating userforms: Connecting Text Box and Combo Box

Directly connecting the text box and combobox to excel and test if the data reaches in Excel on pressing the Submit Button

05:53

Step by step approach to creating userforms: Adding values in the combo box

A combo box when created will be an empty combo box, in this lecture we will see how can we put the values in the combo box

04:40

Step by step approach to creating userforms: Connecting Radio buttons to Excel data

Radio buttons are the ones with "Only One" to be selected, so how to structure the conditional statements to read it through Excel.

07:31

Step by step approach to creating userforms: Connecting check boxes to excel data

Check boxes are the ones where multiple selections can be made, thus we write different conditional statements for each.

09:34

Step by step approach to creating userforms: Making the excel connection intelligent & dynamic

using variables in place of constants and making the connection more dynamic and usable

Testing the form
06:43
Section 3: Getting your App to interact with the user
01:52

Getting your app to interact with the user: why should an app interact with the user

This lecture, explains why is it necessary for us to make the app interactive and how does it saves time an energy at work

07:54

Getting you app to interact with the user: Understanding Property windows & events

In this lecture we will handle the properties of various objects that we have used in the previous lectures and modify these properties based on the user entries.

Eg: when a person types an email id that already exists, the box turns red in color. This happens on a 'while writing it' event.

09:12

Getting your app to interact with users: Creating validations

In this lecture, we explain :

How a validation is Applied through a condition.

When should this be validated

What should be the outcome of validation.

06:50

Getting your app to interact with users: Creating conditional labels

In this lecture we take a similar example of the one that we took in the last lecture. In this case we learn:

How to create a conditionally visible Label.

When should this label interact with the user.

Section 4: Create your own app
Project - create your own app
01:31

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

ATI - Analytics Training Institute, Committed to creating a difference

We are an Analytics firm committed to developing intellectual property that will help individuals and their organisation take smarter decisions every day. ATI, the education arm of Redwood Associates has helped 200 companies and over 15000 individuals speak the language of DATA

The founder Gautam Munshi has nearly two decades of high performance analytics experience. His strong belief that anyone can become an analyst has led him to build a team of 12 - a group of math geeks, techies, musicians, comedians, beer enthusiasts, agriculturists, geneticists, teachers and bankers,who have the gumption that they can make a difference and truly believe that analytics can influence and make a huge impact on a day-day basis. It is this diverse lot that brings Analytics to the mind space of every individual. You can view their moments in the lime light here and follow them on Facebook

Ready to start learning?
Take This Course