Daily Writing Prompt

The Importance of Posting Daily on Your Blog

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!

Daily writing prompt

Who would you like to talk to soon?

View all responses

Userform to enter Tax Details

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 15^th of September, 15^th of December, 15^th of March and on 31^st 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!!

Cheers!

CA Vikram Shankar Mathur

29/Apr/2022 | 20:50 Hours IST

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.

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:

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

Showing A Userform On Right-Clicking A Worksheet Area

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

Computation of Total Income

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

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

20191225-Color-Codes-For-Body-Tag-In-HTML

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

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

Extracting Cell Phone Numbers from Random Strings of variable length?

The basic data was basically of the type shown in the following picture.

The interesting thing about cell numbers is that almost all of them are of 10 digits, at least in India. Hence, a very simple logic was used to achieve results, as shown below:

The logic being to first detect five consecutive numbers and then check if 10 digits that begin with the first five numbers are forming a valid mobile number.

I am not showing the results here, but it is quite obvious 10 digits representing the cell numbers were successfully extracted.

CA Vikram S. Mathur

15th July 2019 (22:10 Hours IST)