Featured

Hello World Macro

The simplest macro in Visual Basic for Applications (VBA) in Microsoft Excel is as per the code below:

Option Explicit

Sub Hello_World()
'---------------------------------------------------------------------------------------
' Procedure : Hello_World
' Author    : vsmathur-onms
' Date      : 17/10/2019
' Purpose   :
'---------------------------------------------------------------------------------------
'

   On Error GoTo Hello_World_Error

    MsgBox "Hello World !!", vbOKOnly

Hello_World_Exit:

    On Error GoTo 0
    Exit Sub

Hello_World_Error:

    MsgBox "Error " & Err.Number & " on Line # " & Erl & " (" & Err.Description & ") in procedure Hello_World of Module m_HelloWorld"
    Resume Hello_World_Exit

    
End Sub
Hello World Macro Step 1
Step 1 – Create Shape or WordArt on Worksheet
Hello World Macro Step 2
Step 2 – Clicking the WordArt Image executes the macro.
Featured

My First Blog Post

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 !!

CA Vikram Shankar Mathur
aka @vsmathurvivaldi
vsmathur@vivaldi.net

20191117-Excel-Running-Total-Formula

Fig-1-Running-Total-Formula-In-Computation-Of-Total-Deductions

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:

=IF(E47=0,0,IF(SUM(E$40:E47)=0,0,IF(SUM(E$40:E47)<=Sec80CLimit,E47,IF(SUM(E$40:E47)>Sec80CLimit,Sec80CLimit-SUM(F$39:F46),0))))

About Vikram Shankar Mathur (vsmathurvivaldi)

The woods are lovely, dark and deep; And I have many promises to keep; And miles to go before I sleep; And miles to go …~ Robert Burns

INTRODUCTION

Vikram Shankar Mathur
(@vsmathurvivaldi)

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.

Besides these, you can also follow these other wordpress sites I maintain (1) vbacoder1962.wordpress.com, or (2) webmaster3011.wordpress.com, or (3) newslettercavsm.wordpress.com. Cheers !!

I am sure you will learn a lot about me if you simple search Google-vsmathurco. CIAO !!
CA Vikram Shankar Mathur