What you'll learn

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

Course content

4 sections • 15 lectures • 1h 21m total length

Why Userforms1: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
Snapshot of the course1: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

Creating an Empty userform in Excel1: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
Creating Controls in the userforms7:10
Step by step approach to creating userforms: Creating Controls

Here we talk about Controls like - Buttons, Text box, checkbox, radio button, dropdown, etc
Connecting Text Box and ComboBox to execute the submission at relevant Events8: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
Adding Values in the combo box5: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
Connecting Radio buttons to Excel data4: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.
Connecting Check Boxes to Excel data7: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.
Making the Excel Connection Intelligent & Dynamic9: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 form6:43

Why should an app interact with the user1: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
Understanding the Property Window & Events7: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.
Creating validations9: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.
Creating conditional labels on 'while writing' event6: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.

Requirements

Any versions of Excel from 2003
Knowledge of VBA in Excel

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.

Who this course is for:

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'll learn

Explore related topics

Course content

Introduction to Excel Apps using Userforms2 lectures • 3min

Step By Step Approach to creating an App in Excel8 lectures • 51min

Getting your App to interact with the user4 lectures • 26min

Create your own app1 lecture • 2min

Requirements

Description

Who this course is for: