Tag: VBA for Beginners
-
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…