Excel VBA – Function and Sub in Excel
Excel VBA - Function and Sub in Excel: The difference between a function and a sub in Excel VBA is that a function can...
Excel VBA – Array in Excel
Excel VBA - Array in Excel: An array is a group of variables. In Excel VBA, you can refer to a specific variable (element)...
Excel VBA – Events in Excel
Excel VBA - Events in Excel: Events are actions performed by users which trigger Excel VBA to execute code.
Workbook Open Event
Code added to the...
Excel VBA – Date and Time in Excel
Excel VBA - Date and Time in Excel: Excel VBA is a powerful programming language that can be used to automate tasks in Excel....
Excel VBA – String Manipulation in Excel
Excel VBA - String Manipulation in Excel: In this chapter, you'll find the most important functions to manipulate strings in Excel VBA.
String Manipulation Functions
Excel...
Excel VBA – Macro Errors in Excel
Excel VBA - Macro Errors: This chapter teaches you how to deal with macro errors in Excel. First, let's create some errors.
The Macro Error...
Excel VBA – Loop in Excel
Excel VBA - Loop in Excel: Looping is one of the most powerful programming techniques. A loop in Excel VBA enables you to loop...
Excel VBA – If Then Statement in Excel
Excel VBA - If Then Statement: Use the If Then statement in Excel VBA to execute code lines if a specific condition is met. The...
Excel VBA – Variables in Excel
Variables in Excel VBA: A variable is a named location in memory that can store a value. Variables are used to store data that...
Excel VBA – Range Object in Excel
The Range object is one of the most important objects in Excel VBA. It represents a single cell or a range of cells on...