Category Archives: Infographic

VSM Calendar

Indeed, getting the Microsoft Calendar control on a userform has tended to become more and more of a difficult proposition, that has prompted me to create a userform that acts like a calendar and I have decided to call it “VSMCalendar”. Just take a look at the image below, then I will explain it’s operation to you.

VSM Calendar
VSMCalendar

Just by looking at the above userform, you will be struck with the familiar similarity of the look of the Microsoft Calendar Control (for those of you who have been used to the control, like me). I was inspired by a similar userform that came with basic coding, to which I added my own colors and coding to use it in my projects. So you must have a worksheet called VSMCalendar to which this control adds the date in two formats, one is the long date format of “DD MMMM YYYY” and the other is the standard date format of “dd/mm/yyyy”. You can change the date by using the combobox for the month and the year and by clicking on the day you want from the command buttons provided, then click on the “OK” button to set the date. The command button programming is largely courtesy the original developer of the userform, but the rest of it is my doing. This userform was also developed in the year 2014-2015, so it is also around eight years old. But it is so easy to operate that it is not funny!!

Cheers!
CA VIkram Shankar Mathur
27-Apr-2022 | 10:50 Hours IST

Calendar View

I got sick and tired of the failure of the Microsoft Calendar from being made a part of my VBA Projects that I created a new kind of Data Entry Form for a Date entry. You can call it anything you want, but I decided to call it “frmCalendarDate” or “MonthView Form”. It looks like this image below:

frmCalendarDate

Basically, the operation of the above is very simple and obvious, and has been inspired by a similar post I saw elsewhere around 15 years ago, but basically requires you to manually feed the year, month and day using the up-down coltrols provided, or you can enter them manually and the data appears in “The Selected Date” textbox, after which you can click the “Date is OK” button and get the date in a designated cell named as “frmCalendarDate” on any worksheet of your choice anywhere in the workbook. That is all there is to it, folks!! Like it? Follow my blog if you do, I am putting up numerous posts and will continue in the near future to do so. Cheers !!

CA Vikram Shankar Mathur
24-Apr-2022 | 10:52 Hours IST

Manage your own Salary Register

Take a look at the screenshot given below of the Salary Register (in Microsoft Excel 2007/2013/2016/365 format). There are a number of columns for income heads under salary and a fewer number of columns for deduction heads under salary. Notice that you can change a particular head if it does not apply to you to something that does apply to you. For example, Dearness Allowance (DA) could be renamed to Flexible Allowance or Personal Allowance etc. Most of the deduction heads have been well thought off, still the same applies to them as well. Of course, you also have to remember that something like Labour Welfare Fund (LWF for short) comes just twice in the year in most concerns that I have seen, yet you will have to show it for 12 months!!

http://vbacoder1962.blogspot.com/2022/04

Below the salary register data for 12 months you will also find a place where you an keep a record of the investments that you have to make under Section 80C, whether it be Provident Fund, Life Insurance Premium, Public Provident Fund etc. The design was made by yours truly for a concern where I had been auditor for a good many years. This worksheet contains everything one would need to prepare the Computation of Salary Income for any particular employee, including yourself. Cheers !!

CA VIKRAM SHANKAR MATHUR
12-Apr-2022 17:34 Hours IST

Are you willing to sponsor my developmental activities?

If you are willing to sponsor me for my developmental activities, which includes purchase of book(s) and software(s) that are required to keep the mind focused on the long journey of development of any software, then you can use the following details to transfer whatever funds that you can spare towards my development fund. Of course, I will issue you a legally acceptable invoice, if you need it. Also, I will provide the basic financials about how I intend to use the money that you would be so kindly providing, so that you know where the funds will be used. Thanks in advance.

Starting from January 2025, I am also learning Python Programming, and it is one of the most interesting languages that I will ever learn, because it has so many ways in which it can be implemented. Moreover, it is fully supportive of Object Oriented Programming (OOP), which we will be discussing in another post.

Another interesting update that I wish to share with you, my dear readers, is that I am also learning Artificial Intelligence, with effect from April 2025, and I think that the future would be simply amazing with it!!

CA VIKRAM SHANKAR MATHUR
First Updated on 14-Apr-2022 | 07:33 Hours IST
Last Updated on 11th May, 2025 | 12:50 Hours IST

<<== Back to Main