Basics of VBA / Macros Chapter â 68 (Application Object Part-1)
Application Object The mother of all objects is Excel itself. We call it the Application object. The application object gives access to a lot ofâŚ
Read article âCategory Archives: Excel VBA
Step-by-step VBA lessons and ready-to-use macros.
Basics of VBA / Macros Chapter â 67 (Function and Sub Part-5)
Basics of VBA / Macros Chapter â 67 (Function and Sub Part-5)
ByRef and ByVal You can pass arguments to a procedure (function or sub) by reference or by value. By default, Excel VBA passes arguments by reference. As always, weâŚ
Read article âBasics of VBA / Macros Chapter â 66 (Function and Sub Part-4)
Basics of VBA / Macros Chapter â 66 (Function and Sub Part-4)
Volatile Functions By default, UDF's (User Defined Functions) in Excel VBA are not volatile. They are only recalculated when any of the function's arguments change. A volatileâŚ
Read article âBasics of VBA / Macros Chapter â 65 (Function and Sub Part-3)
Basics of VBA / Macros Chapter â 65 (Function and Sub Part-3)
Custom Average Function Below we will look at a program in Excel VBA which creates a User Defined Function that calculates the average of a randomly selected range excludingâŚ
Read article âBasics of VBA / Macros Chapter â 64 (Function and Sub Part-2)
Basics of VBA / Macros Chapter â 64 (Function and Sub Part-2)
User Defined Function Below we will look at a program in Excel VBA that creates a User Defined Function. Excel has a large collection of functions. InâŚ
Read article âBasics of VBA / Macros Chapter â 63 (Function and Sub Part-1)
Basics of VBA / Macros Chapter â 63 (Function and Sub Part-1)
Function and Sub The difference between a function and a sub in Excel VBA is that a function can return a value while a sub cannot. Functions and subs becomeâŚ
Read article âBasics of VBA / Macros Chapter â 62 (Arrays Part-5)
Basics of VBA / Macros Chapter â 62 (Arrays Part-5)
Size of an Array To get the size of an array in Excel VBA, you can use the UBound and LBound functions. Place a command button on your worksheetâŚ
Read article âBasics of VBA / Macros Chapter â 61 (Arrays Part-4)
Basics of VBA / Macros Chapter â 61 (Arrays Part-4)
Month Names Below we will look at a program in Excel VBA which creates a User Defined Function that uses the Array function to return the names of theâŚ
Read article âBasics of VBA / Macros Chapter â 60 (Arrays Part-3)
Basics of VBA / Macros Chapter â 60 (Arrays Part-3)
Array Function The Array function in Excel VBA can be used to quickly and easily initialize an array. Place a command button on your worksheet and add the following codeâŚ
Read article âBasics of VBA / Macros Chapter â 59 (Arrays Part-2)
Basics of VBA / Macros Chapter â 59 (Arrays Part-2)
Dynamic Array If the size of your array increases and you don't want to fix the size of the array, you can use the ReDimâŚ
Read article âBasics of VBA / Macros Chapter â 58 (Arrays Part-1)
Basics of VBA / Macros Chapter â 58 (Arrays Part-1)
Array An array is a group of variables. In Excel VBA, you can refer to a specific variable (element) of an array by using the array name and theâŚ
Read article âBasics of VBA / Macros Chapter â 57 (Events Part-6)
Basics of VBA / Macros Chapter â 57 (Events Part-6)
Rolling Average Table Below we will look at a program in Excel VBA that creates a rolling average table. Place a command button onâŚ
Read article â