Excel VBA Userforms - Basic to Advance with Projects Series6

person icon Ajay Parmar

Excel VBA Userforms - Basic to Advance with Projects Series6

UserForms and Automations using them

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Ajay Parmar

architecture icon Excel VBA,Office Productivity,Microsoft


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

Knowledge of VARIABLES LOOPS and Collection Loops and use of filesystemobject library is an added advantage prior buying this course.

You will learn everything about USERFORM automation here. From basic to super advance.

You will see the use of events -self triggered macros in forms.

i have shared the great tips with you which we use in userforms to make them powerful and useful dashboards.

Know how to work and design combo box, list box, option buttons and checkbox, labels, date pickers

How to create real time advance dashboards using USERFORMS.

How to link listbox with another list box and how to link combo with list box

How to use events like form initialize event, text box change and after update events.

What is the difference between these events and how many more such events one can use

Explore the most used and versatile control - listbox in userform. Learn how to loop through listbox items

How to check which is selected item in list box and how to grab that selected item value and use it

How to create a listbox with multiple columns and show entire data in it . Check the Voucher dashboard.

All files you can download and any assistance needed, you can ask me.


What will you learn in this course:

  • Course is focusing on basic level developers who know arrays. loops and variable pretty well and now want to take their knowledge to next level by creating super advance USERFORMS which uses all these topics.

  • From designing to programming and what things to be kept in mind while making user-forms. 

  • Collection loops structure in User-forms and their use practically.

  • User-forms are very important part of VBA and one cannot be known as a great programmer if he or she does not know userforrms. This is not just a basic level information tutorial on FORMS but you shall see here loops, if functions, variables use and collections loops is applied . After-all. there is nothing better than practical learning so i have great MIS Projects as well for you.

  • Many good short projects for you on user forms.

  • Deep study on controls like Combobox,Listbox,textbox,labels,command buttons,date time calendars,frames - everything discussed from sctrach

  • Use of forms Events like Change event, Click event, initialize event, Close event and Update events is discussed in detail.

  • Which event should you choose and why.

  • How to debug the Userform codings. 

  • See the use of Global variable sin USERFORM and lean why local or module level variables can fail.

  • Create Move next button in forms to see the data one by one coming from excel

  • Advance level and practical projects and assignments with ready made codes is added as well.


What are the prerequisites for this course?

  • Knowledge of VARIABLES LOOPS and Collection Loops and use of filesystemobject library is an added advantage.
  • if you are not aware of arrays and loops in VBA , I request you to please see my previous series on same as we have extensively used these in Userforms.
Excel VBA Userforms - Basic to Advance with Projects Series6


Check out the detailed breakdown of what’s inside the course

13 Lectures
  • play icon Demo 05:24 05:24
  • play icon Useform Controls- Basics
  • play icon Basics 01:33:17 01:33:17
  • play icon Making of school dashboard and File Folder Dashboard
  • play icon Dashboard 01:12:08 01:12:08
  • play icon Move Up items in ListBox - Awesome
  • play icon Up button 16:01 16:01
  • play icon Scroll down functionality in Listbox
  • play icon Scroll down 17:15 17:15
  • play icon Depended Combo Boxes
  • play icon Dynamic combos 15:03 15:03
  • play icon Make this Voucher Management Dashboard
  • play icon Real practical project - Voucher Management 44:34 44:34

Instructor Details

ajay parmar

ajay parmar

Data Analytics Trainer

I have been teaching online from 10 years now and teaching is my hobby and passion. I cannot think of anything better than teaching and shaping up students career. Enroll today and take your knowledge to the next level. My training content is my proud and you will not be disappointed. I teach advance Excel, Excel VBA, MS Access, Access VBA, PowerQuery, M code in Powerquery, PowerPivot,DAX Formulas,Power BI and WebScraping using html libraries in VBA.

Show less

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us