TreeView and ListView in VBA

An advanced VBA & Macro application training, this will help you learn how to create a useful project management tool using treeviews and listviews.

5

 2h 23m | 19 Videos | 67482 Views |   Expert

Creating a Basic Project Management Tool with Treeview & Listviews

The main course objective of this online training is to deliver the knowledge of advanced options that a user can apply to create a CRM tool without using any coding or intense programming. VBA and Macros are the best tools that an employee can use to automate processes.

Visual Basic for Applications (VBA) is a programming language which is event driven. This language is efficient to build proper user defined functioning commands, process automation and also allows a user to use Application Program Interface of Windows. Excel VBA with the help of Macro makes the programming part easier for the user.

The training includes the following topics:

• Basic Controls in VBA
• Additional Controls
• Adding References
• Overview of Advanced Controls
• Listviews
• Adding Listview to Userform
• Properties of Listview
• Events of Listview
• Methods of Listview
• Populating data in Listview
• TreeViews
• Adding Treeview to Userform
• Properties of Treeview
• Events of Treeview
• Methods of Treeview
• Population data in Treeview
• Creating a Basic Project Management Tool with Treeview & Listviews

Target Customers:

• • • Commerce students
    • Students from the business administration
    • Chartered Accountants
    • Working professionals who go through the hectic working schedule of same repetitive work every day can do the training and make their life easier

Pre-Requisites:

• • • • • Basic knowledge of using VBA and Macros
        • Basic experience in using Microsoft Access
        • The course is fit for anyone who has the urge to learn applications of VBA
        • No specific education background and work experience required

Back to top ▴