1. Excel VBA basics: Data types, DIM & SET (Learn to use them correctly)

    Excel VBA basics: Data types, DIM & SET (Learn to use them correctly)

    3
    0
    5
  2. Excel VBA: Loop through cells inside the used range (For Each Collection Loop)

    Excel VBA: Loop through cells inside the used range (For Each Collection Loop)

    3
    0
    4
  3. Reset Dependent Drop-down in Excel (with a tiny bit of VBA)

    Reset Dependent Drop-down in Excel (with a tiny bit of VBA)

    3
    0
    24
  4. Excel VBA FIND Function (& how to handle if value NOT found)

    Excel VBA FIND Function (& how to handle if value NOT found)

    3
    0
    12
  5. Excel VBA: Check If File or Folder Exists (DIR) - Open File or Create Folder

    Excel VBA: Check If File or Folder Exists (DIR) - Open File or Create Folder

    3
    0
    17
  6. How to use the Message Box in Excel VBA (syntax you'll need for msgbox)

    How to use the Message Box in Excel VBA (syntax you'll need for msgbox)

    3
    0
    27
  7. How to SUM Cells by Color in Excel (Get it to update automatically)

    How to SUM Cells by Color in Excel (Get it to update automatically)

    3
    0
    17
  8. Excel VBA tutorial for beginners: The Visual Basic Editor (VBE)

    Excel VBA tutorial for beginners: The Visual Basic Editor (VBE)

    3
    0
    32
  9. Excel VBA tutorial for beginners: Object Properties & Methods

    Excel VBA tutorial for beginners: Object Properties & Methods

    4
    0
    70
  10. Excel VBA IF THEN Statement (with ELSEIF & Looping in cells)

    Excel VBA IF THEN Statement (with ELSEIF & Looping in cells)

    3
    0
    30
  11. Excel VBA: Referring to Ranges & Writing to Cells (Range, Cells, Offset, Names)

    Excel VBA: Referring to Ranges & Writing to Cells (Range, Cells, Offset, Names)

    5
    0
    45