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.
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
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
Step by step approach to creating userforms: Creating Controls
Here we talk about Controls like - Buttons, Text box, checkbox, radio button, dropdown, etc
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
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
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.
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.
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
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
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.
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.
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.
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