Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel VBA In-Depth USERFORMS Series7 ( 7hrs Amazing Content)
Rating: 4.2 out of 5(22 ratings)
196 students
Created byajay parmar
Last updated 3/2022
English

What you'll learn

  • You will learn everything about USERFORM automation here. From Basic to Super advance and I mean it.
  • 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.
  • How to move up and move down the listbox items.
  • Why you use additem or excel source data in combobox and listbox - Pros and Cons
  • How to use scripting library classes like file system object in forms. What can be achieve via this library
  • All files you can download and any assistance needed, you can ask me.

Course content

1 section • 12 lectures • 7h 27m total length

  • Introduction to Excel VBA UserForms5:24
  • Introduction to UserForms Controls and properties30:00

    • How to insert a Useform and its control names.

    • How to insert userform controls like text box, combo box, lables, listbox, CheckBox, Option Buttons.

    • How to align them in userform window.

    • How to see property window of each of the controls and why we need it and what we can do using this window.

  • Creating a School Dashboard - So much fun and knowledge1:03:25

    • Let us create a School Dashboard using forms. Using the controls in this practical application.

    • Introducing frame control

    • How to start coding these controls like combo, option and text boxes. Get clarity on fundamentals.

    • Learn the default Events in userform and which one to choose and why and how.

    • In this project we are using loops , range commands and if conditions so data submitted in form can go to its real source quietly

  • Code ListBox and use EVENTS plus one more Userform to handle file folders1:12:08

    • We are continuing the dashboard here. We are coding the listbox and other controls using loops and understanding the list box loops

    • Let us understand form events too like initialize,update and change events by taking the help of this practical scenario.

    • Learn about listbox properties like count, selected index.listcount

    • Another userform shown which is showing the files based on combo box drives. It is a different form view with different goals.Enjoy

  • Scroll up in ListBox16:01

    What if you need to change index of selected items in listbox. It is so important to know because this then brings the flexibility in your  dashboard. User can anytime move the items upward.

  • Scroll down functionality in Listbox17:15
  • Dependent ComboBoxes15:03

    Using onchange event here, we are linking one combo box with another. It is quite simple. Have fun!

  • Make Break Timer - Project on Student request44:55

    Excellent project to be seen if you are interested in seeing the power of VBA Userforms. Get this idea of preparing break time scheduler and use it in your office and get your boss drool over you.

  • Your questions my solution - Wonderful tricks for project32:39

    i am sharing three questions asked by you with practical examples

    • what is change event and after update event in userforms and the difference and why and where what is to be used

    • how to show calculation in a text box when two other textboxes have some values entered by user

    • how to auto convert every letter typed in the textbox into uppercase

  • Create Move Next BUTTON - Useful tip for your Project42:58

    how to use advance filter technique in creating buttons like move next and move previous which helps you in scrolling the data in any direction. This video is very useful for students because many times we need this sort of requirement in userforms

  • How to create Voucher tickets for your team.1:03:13

    This is the super advance side of user forms. In this lecture you will use arrays, loops, vlookup functions to fully automate the forms.

    We are creating a form which helps us in tracking the voucher numbers being issued to team mates as to when it was issued to them , when it is exhausted. This form is tracking everything.

  • How to Create Voucher Part244:34

Requirements

  • 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.

Description

  • 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 user forms. 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. For eg. How to move up or down the items available in list box using loops, IFs and Arrays.

  • Deep study on controls like Combo box,List box,text box, labels ,Command buttons, date time calendars, frames - everything discussed from scratch

  • 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. Full explanation by taking practical scenarios.

  • How to debug the Userform coding as you cannot directly debug using F8.

  • 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

  • How to connect combo box with list box and why . For eg. if i change folder in combo box then my files under that folder should appear in list box.

  • Use Amazing Scripting library classes like fileSystemObject in User forms.

  • Advance level and practical projects and assignments with ready made codes is added as well. Just added a Tracking Voucher project for you, It is super duper fun and highly advance, Enjoy the automation.

Who this course is for:

  • Students who want to create awesome USERFORMS which also get used in excel dashboards should go for this course.

Report abuse