Basics of VBA / Macros Chapter – 75 (ActiveX Controls Part-4)
Combo Box A combo box is a drop-down list from where a user can select an item or fill in his/her own choice. To…
Read article →Category Archives: Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
Basics of VBA / Macros Chapter – 74 (ActiveX Controls Part-3)
Basics of VBA / Macros Chapter – 74 (ActiveX Controls Part-3)
List Box A list box is a list from where a user can select an item. To create a list box in Excel VBA, execute the following…
Read article →Basics of VBA / Macros Chapter – 73 (ActiveX Controls Part-2)
Basics of VBA / Macros Chapter – 73 (ActiveX Controls Part-2)
Text Box A text box is an empty field where a user can fill in a piece of text. To create a text box in Excel VBA,…
Read article →Basics of VBA / Macros Chapter – 72 (ActiveX Controls Part-1)
Basics of VBA / Macros Chapter – 72 (ActiveX Controls Part-1)
ActiveX Controls Learn how to create ActiveX controls such as command buttons, text boxes, list boxes etc. To create an ActiveX control in Excel VBA, execute the…
Read article →Basics of VBA / Macros Chapter – 71 (Application Object Part-4)
Basics of VBA / Macros Chapter – 71 (Application Object Part-4)
Write Data to Text File Below we will look at a program in Excel VBA that writes an Excel range to a CSV (comma-separated-value) text file. Place…
Read article →Basics of VBA / Macros Chapter – 70 (Application Object Part-3)
Basics of VBA / Macros Chapter – 70 (Application Object Part-3)
Read Data from Text File Below we will look at a program in Excel VBA that reads data from a text file. This file contains some geographical…
Read article →Basics of VBA / Macros Chapter – 69 (Application Object Part-2)
Basics of VBA / Macros Chapter – 69 (Application Object Part-2)
StatusBar The StatusBar property of the Application object in Excel VBA can be used to indicate the progress of a lengthy macro. This way, you can let the…
Read article →Basics of VBA / Macros Chapter – 68 (Application Object Part-1)
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 →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 →