Project on Microsoft Excel VBA - Attendance Register
Project on Excel VBA - Attendance Register using Microsoft Excel VBA
Updated on Jun, 2025
Language - English
Office Productivity,Microsoft,Excel
Lectures -24
Duration -2.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
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
- List views
- Adding List view to User form
- Properties of List view
- Events of List view
- Methods of List view
- Populating data in List view
- Tree Views
- Adding Tree view to User form
- Properties of Tree view
- Events of Tree view
- Methods of Tree view
- Population data in Tree view
- Creating a Basic Project Management Tool with Tree view & List views
Who this courses is for:
- 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
Prerequisites
- 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
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
1 Lectures
-
Introduction to Attendance Register Using Excel VBA
07:03
07:03
Create Project Interface
6 Lectures
Generate Student Id in Attendance Register
14 Lectures
Display Date and Save Mark
3 Lectures
Instructor Details
Corporate Bridge Consultancy Private Limited
Corporate Bridge Consultancy Private Limited - EDUCBA is an initiative by IIT IIM Graduates, We are one of the leading providers of skill-based education addressing the needs of 1,000,000+ members across 70+ Countries. With more the 15+ years of experience in Training and Development, our expertise lies in Self-paced learning, Digital Learning content, Corporate Training, Content Development and Consultancy.
Our Vision:
To be a leading and progressive partner with our clients in their journey of progress.
"We are passionate about our work. We believe in empowering and improving our members’ lives with skill-based, hands-on training programs."
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now