“Visual Basic for Applications (VBA) is an implementation of Microsoft‘s event-driven programming language Visual Basic 6, which was declared legacy in 2008, and its associated integrated development environment (IDE). Although pre-.NET Visual Basic is no longer supported or updated by Microsoft, the VBA programming language was upgraded in 2010 with the introduction of Visual Basic for Applications 7 in Microsoft Office applications.[1]“ ~ Wikipedia
Be yourself; Everyone else is already taken.
— Oscar Wilde.
One of the most interesting things that I would like to share with you – my reader – as a point of interest is related to the quote above, that happens to be one of my #Favourite #Quotes, is that had it not been for my first boss in me first job in the industry, in a Multi-National-Company (MNC) – which I am sure many of you would have heard of, especially if you are an Indian – called Ingersoll-Rand (India) Limited or IRIL for short. He was the Factory-Controller-Cum-GM (Finance) then, and I cannot name him publicly, short of saying that he was another Chartered Accountant, just like me. However, it was my first job as a qualified professional in their Internal Audit Department, as an Internal Audit Officer (Grade III). Why it is important is that he insisted that every piece of paper I brought to him, should be prepared on the computer, using the available packages of that time, remember, in 1988-89, the only software that was available was in the good old DOS Operating System, so we had WordStar as the word processor, Lotus 1-2-3 as the spreadsheet and dBase / FoxPro as the data processing software(s). Then when in 1995, Microsoft launched it’s Windows 3/3.1 with Microsoft Excel, Microsoft Word and Microsoft Access as their spreadsheet / word processor / database software, it was a breeze for me to adapt to them.
More to you on this in my future posts. Happy Reading !! Cheers !!
They say a picture speaks what a thousand words cannot express, and that is the reason I prepared the above picture painstakingly in Microsoft Powerpoint, beginning by taking a screenshot of the worksheet showing the running total as a part of the calculation of the qualifying amount of the deductions u/s 80C under the various heads depicted from serial (a) to (f) under serial no. 5. Thereafter I added three other shapes, and the various captions and finally the explanation of the formula itself. If you want a copy of the formula, here it is in a copy-able format below:
Basically, I am a Chartered Accountant from Ahmedabad, Gujarat, India. Originally, I began my career as a Professional employed in the Industry for about 5 years upto 1995, when I switched to Practice as an individual practitioner holding my own Certificate of Practice. If you want to learn more about me, you can visit my other blogs (1) www.cavsmathur.net (2) vsmathur.co.in or (3) www.ahmedabadfca.org or (4) vsmathucoin.blogspot.com, or (5) blog.cavsmathurin.com, or (6) www.ktvayedaco.com.