Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
7 Hour(s) 27 Minute(s)
Language
English
Taught by
ajay parmar
Rating
Course Overview
Covering every type of useful form controls . From their design to coding - I have everything for you here.
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.
Course Content
- 1 section(s)
- 12 lecture(s)
- Section 1 Introduction
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.
Skills covered in this course
Reviews
-
JJim Klyman
annoying bass audio noise with keyboard entry. Tends to over explain things when working through examples would better demonstrate the topic.
-
MMark Williamson
First half of the course was good.
-
AAmos Lucas H. Amosse
Its an interesting course that also opens the door to other programming languages. I love MS Excel.
-
MMartial A Bandemer
Making errors in demo code causes confusion
