-
VBA Conditional Statements
Conditional statements are the building blocks of decision-making in programming. They allow programs to adapt their behavior based on specific conditions, creating intelligent and dynamic applications. In this post, let’s explore how we can use conditional statements in VBA to make our Excel projects smarter and more responsive. Types of Conditional Statements In VBA, we…
-
Creating a VBA Function
In the previous post, we saw the example of a macro or a subroutine which calculated the hypotenuse of a right angled triangle. While subroutines and macros are quite useful, in that particular example, it would be more useful to have a custom function built which can be called, as and when required. Most MS…
-
Visual Basic for Applications
One of the coolest Excel features – in addition to the vast repositories of functions that are available in its spreadsheets – is VBA or Visual Basic for Applications. It allows a user to create a procedure – or a macro – to perform more advanced calculations or automate repetitive calculations. Accessing VBA 3. Once…
-
Spreadsheets: Common man’s programming tool
I remember sitting in my computer science class about two decades ago and my teacher teaching us how to print “Hello World”. I never became a computer scientist – nor did I become a professional programmer. But I did come to appreciate how useful programming is for most professions. As an experimental Materials Scientist, I…