Excel VBA – Record and Run Macros using the Excel Macro Recorder

  Excel VBA – Record and Run Macros using the Excel Macro Recorder Applicable to Excel 2007 ———————————————————————— Contents: Start Recording a Macro – the Record Macro dialog box Naming a Macro Assign a Keyboard Shortcut Store a Macro Add a Description Recording a Macro View, Edit & Run a Recorded Macro Use Relative References...

Visual Basic Editor in Excel (VBE) – the VBA Code Editor

Visual Basic Editor in Excel (VBE) – the VBA Code Editor ———————————————————- Contents: Launch the Visual Basic Editor Visual Basic Editor components Code Window Project Explorer Properties Window The Programming Workspace ———————————————————- The Visual Basic Editor (VBE) in Excel is an environment used to write, edit and debug VBA code, and is contained in the...

Excel VBA: Calling Sub Procedures & Functions, Placement in Modules

Excel VBA: Calling Sub Procedures & Functions, Placement in Modules ——————————————————————————– Contents: Sub procedures, Function Procedures & Property Procedures Naming Rules & Conventions for Procedures VBA Procedures Scope – Public vs Private Placement of Macros / Sub procedures in appropriate Modules Calling Procedures Executing Procedures ——————————————————————————– Sub procedures, Function Procedures & Property Procedures A VBA...

Excel VBA: Passing Arguments to Procedures, Parameter Arrays (ParamArray)

  Excel VBA: Passing Arguments to Procedures, Parameter Arrays (ParamArray)   ——————————————————————————————————— Contents: Argument Data Types Passing Arguments By Value Passing Arguments By Reference Optional Arguments Pass an Arbitrary or Indefinite Number of Arguments – Parameter Arrays (ParamArray) ———————————————————————————————————   When an external value is to be used by a procedure to perform an action,...

Excel VBA Custom Classes & Objects, Class Modules, Custom Events

Excel VBA Custom Classes & Objects, Class Modules, Custom Events ————————————————————— Contents: Custom Classes and Objects Custom Class Events ————————————————————— In vba you can create your own custom objects by defining classes & inserting class modules. You can also create your own custom class events, in addition to Excel’s own inbuilt event procedures. In this...

Scroll to top