VBA – User Form & Controls A UserForm is a custom-built dialog box that makes a user data entry more controllable for you and
VBA – Filters and Reporting AutoFilter is applicable to a column or a set of columns. It filters data depending on the given criteria.
Events and Event Procedures were introduced in Excel97. Earlier versions of Excel do not support events. An Event is an action initiated either by
Select-Case statement, also called as Switch Case in some other languages, checks a variable for different cases or values. If anyone of the case
VBA- Arrays An array is a way to store more than one value with a common name. By definition, “An array is a group of
Variable in VBA Variables are used to store temporary information, used for execution within the Procedure, Module or Workbook Variable Naming Rules 1) A Variable
While it is common to declare many variables and use them individually throughout code, this is not always the best practice. So using with