VBA-Code-Library-2024

December 13, 2024: With effect from this day of December, 2024, I am creating a library of the code modules that I have created over the last 12-15 years, for the various projects that I only have created for my own personal use. This page is dedicated to my alter-ID's deadlyvbaprogrammer@gmail.com, vbaprogrammer.2006@gmail.com and vbacoder.1962@gmail.com - all of whom have been regular contributors for this purpose.

January 28, 2025: It has been more than one and a half months, and I have been doing all kinds of things, except working on the code for my VBA (Visual Basic for Applications)  Code Library 2024! Maybe I will have to call the next project VBA-Code-Library-2025!!

CA Vikram Shankar Mathur

vsmathurcoin

ahmedabadfca

vikramsmathur

vbacoder.1962

cavs.mathur

deadlyvbaprogrammer

exceltrainerahmedabad

vbabeginner

advvba

indvbapro

Excel-VBA-AhmFCA

cavsmathuroutlook

Userform # 1: This userform is a Customer Database Management System, which was actually designed as an Access Form, but we adapted it as a VBA USerform. Basically, using the same userform, you can Add / Modify or Change / Delete a Customer Record. To Add a new customer, you press the "Clear" button and then proceed to fill the FirstName, Company, Address, etc. details provided on the upper left side of the userform, and to edit / delete an existing customer, simply click on the details in the ListBox and then proceed. (Explanation Added on 11-June-2025).

Figure # 2: This is just an Excel-VBA Logo created by me. (Explanation Added on 11-June-2025).

Figure # 3: A graphic explaining the reason why one should learn VBA Programming. (Explanation Added on 11-June-2025).

Figure # 4: Again, listing down some reasons why you ought to do VBA Programming! A Cash Payment Voucher, an example of a VBA File Explorer and another sample of a Cash Payment Voucher. (Explanation added on 11-June-2025).

Figure # 5 : What is VBA? (Explanation added on 11-June-2025).

Userform # 6: Basically, a VBA Userform that collects information pertaining to a particular TDS (Tax Deducted at Source) Deductee in the case of Income-Tax Return (ITR) filing case. (Explanation added on 11-June-2025).

Userform # 7: A VBA Userform that was used in my Saral2D ITR System, created in the year 2003-2004. (Explanation added on 11-06-2025).

Userform # 8: A VBA Userform that was used to collect information relating to an Assessee, whose Income-Tax Calculation was being done. (Explanation added on 11-06-2025).

Userform # 9: A VBA Userform that was used to create a Customer's Bio-Data (CV). (Explanation added on 11-06-2025).

Userform # 10: A userform that was used for saving client information (This was NOT created by me, simply adapted from an Excel File that I had downloaded from the internet, I forget which website, though). (Explanation added on 11-06-2025).

CA Vikram Shankar Mathur
Updated: June 11th, 2025