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
There comes a time when we all resort to coding the VBA, just to get some odd task completed, right?
Be yourself; Everyone else is already taken.
— Oscar Wilde.
This is the first post on my new blog. I’m just getting this new blog going, so stay tuned for more. Subscribe below to get notified when I post new updates.
Maintaining a blog requires dedication and consistency, and posting daily can significantly enhance your blog’s effectiveness and reach. Here are several reasons why daily blogging is important:
1. Enhanced Engagement
Regular posts keep your audience engaged and coming back for more. Daily content gives readers something new to look forward to, fostering a loyal community around your blog.
2. Improved SEO
Search engines favor fresh content. By blogging daily, you increase the likelihood of your site being crawled more frequently, which can improve your search engine rankings and visibility.
3. Skill Development
Writing every day hones your skills, making you a better writer over time. You’ll learn to articulate your thoughts more clearly and creatively, which can enhance the quality of your posts.
4. Increased Traffic
More posts mean more opportunities for traffic. Each new article is a chance to attract new visitors who may discover your blog through search engines or social media.
5. Establishing Authority
Daily blogging helps establish your credibility in your niche. Sharing your knowledge consistently can position you as an expert, attracting a dedicated following that respects your insights.
6. Content Variety
Posting daily allows you to explore different topics and formats, keeping your content diverse and interesting. This variety can attract diverse audiences and maintain current readers’ interest.
7. Building a Routine
Creating a habit of daily writing instills discipline and structure in your blogging routine. This can lead to a more organized approach to content creation and help in planning future posts.
8. Feedback and Improvement
Frequent posts provide more opportunities for reader interaction and feedback. Engaging with your audience can offer insights into what they enjoy, allowing you to tailor your content more effectively.
Conclusion
While daily blogging requires commitment, the benefits are substantial. From enhanced engagement and SEO to skill development and authority building, establishing a daily posting routine can greatly impact your blogging journey. Embrace the challenge, and watch your blog flourish!
This is a userform that has been adapted from one of my pet projects called “Saral0506” wherein the form was used to feed the details of the Advance Taxes, Interest and Self-Assessment Taxes into the respective places in the control worksheet. Take a look at the userform itself before I explain the usage of the same.
Figure 1 : Userform to enter taxes
In the userform shown above, there is a provision for entering the data for the four due dates of Advance Taxes, namely on the 15th of September, 15th of December, 15th of March and on 31st of March of the financial year. So, you have the date tax was paid, the BSRCode & Challan No (trfVchNo) mentioned on the challan and the amount paid on that date. Based on that information, if the checkbox for calculating the interest has been checked, the interest under the three sections of 234A/234B/234C is calculated. Obviously two other inputs are required for this to be done accurately and those are the amount of tax that is due for the year and the tax deducted at source. There is another userform before this one that takes that input, and since we are not talking about that form yet, let us continue how this form operates, assuming that those two figures have been already provided in the Computation of Total Income Worksheet already discussed elsewhere. Then comes the upto four Self-Assessment Challans that can be fed into the system based on the Computation of Total Income that we have discussed elsewhere. Once you click the button called “Post It!”, the said information gets posted into the Computation of Total Income and that’s all there is to it, folks!!
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.
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
You might have been used to using an existing worksheet of the workbook you regularly work on as a data-entry format, say, maybe like a Cash / Bank Payment Voucher Entry Sheet.
Obviously, the right click event can only be controlled using VBA, the sheet_rightclick event controls that. You need to set the cancel variable to true and then use code to show the userform instead.
Currently, I am working on a worksheet that contains the assessee information, as shown below.
And here is the userform that will show when I right-click the worksheet.
As you can see, it captures all the information needed to store the information about any assessee. At the moment it is a work in progress and woulod be combined with another worksheet, say, the Income-Tax Return worksheet, to prepare the income-tax return of the assessee.
Cheers !!
CA Vikram Shankar Mathur 23-April-2022 : 09:12 Hours IST
Three screens depicted above are actually one worksheet, starting with the first screen showing some statutory details of the assessee (in our case the same employee whose salary register gives the details that are required in the second screen). This computation basically would work for only the salary income portion, even though those of you with sharper eyes would detect that income from house property, business income, capital gains and income from other sources can also be fed into these sheets. However, then the Income Tax Return ITR1 would not apply, rather some other appropriate ITR would have to be prepared. We are not going into which ITR for which set of circumstances, suffice to say that this computation is versatile enough to serve any purpose. In the workbook that I ultimately set up in combination would technically allow no entry except in the fixed details section that is Part A.
Recall that the Salary Register has a space where some investments can be declared by the assessee/employee? Those details would automatically get added to the second screen that is the beginning of Part B of the computation. Finally the third screen does the actual computation of the income with inputs about Advance Tax, Self-Assessment tax and interest and other taxes, including Tax Deducted at Source details (other then the Section 192 details which come from the salary register itself). The final purpose being the estimation of the appropriate Tax Deducted at source under section 192 of the Income-Tax Act, for the balance period for which the payslips are yet to be prepared. Once the entire 12 months are entered, one would get an idea about the tax liability of the employee for that particular financial year.
Cheers !
CA Vikram Shankar Mathur 15-Apr-2022 | 06:26 Hours IST
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!!
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
When posting to a blog, you might want to change the color of the background by using the color values in the <BODY> tag. The table above gives the relevant values that you will need. The code necessary to do this is:
<body color="#FFFFFF">
</body>
CA Vikram Shankar Mathur 25-Dec-2019 | 11:50 Hours IST
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
You must be logged in to post a comment.