VBA

What is VBA Array? An array is defined as a memory location capable of storing more than one value. The values must all be of the same data type. Let’s say you want to store a list of your favourite beverages in a single variable, you can use VBA array to do that. By using…

Variables are used in almost all computer program and VBA is no different. It’s a good practice to declare a variable at the beginning of the procedure. It is not necessary, but it helps to identify the nature of the content (text, data, numbers, etc.) VBA Variables Variables are specific values that are stored in…

Everybody in this country should learn how to program a computer… because it teaches you how to think.” -Steve Jobs I wish to extend the wise words of Steve Jobs and say everyone in the world should learn how to program a computer. You may not necessary end up working as a programmer or writing…

What is an Excel Macro? Excel Macro is a record and playback tool that simply records your Excel steps and the macro will play it back as many times as you want. VBA Macros save time as they automate repetitive tasks. It is a piece of programming code that runs in an Excel environment but…