Excel VBA Userforms - Basic to Advance with Projects Series6

Goals

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.

Prerequisites

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.