Learn to harness the power of Excel VBA and macros through a comprehensive tutorial series. Master essential skills including macro recording, navigating the Visual Basic Editor, understanding objects, properties, and methods in VBA, efficiently referencing ranges and writing to cells, implementing copy and paste operations, creating loops, and utilizing message boxes. Gain practical knowledge through hands-on examples covering topics such as data manipulation across sheets, conditional statements, array usage, file and folder management, and creating interactive elements like combo boxes and list boxes. Discover advanced techniques for automating tasks, enhancing spreadsheet functionality, and streamlining workflows to boost productivity in Excel.
Overview
Syllabus
Excel VBA: Copy Data from one Sheet to Another (Absolute Vs. Relative Macro Recording).
Excel VBA tutorial for beginners: The Visual Basic Editor (VBE).
Excel VBA tutorial for beginners: Object Properties & Methods.
Excel VBA: Referring to Ranges & Writing to Cells (Range, Cells, Offset, Names).
Copy & Paste in Excel VBA (copy, pastespecial, resize & offset).
Excel VBA basics: Data types, DIM & SET (Learn to use them correctly).
Excel VBA IF THEN Statement (with ELSEIF & Looping in cells).
Excel VBA: Loop through cells inside the used range (For Each Collection Loop).
How to use the Message Box in Excel VBA (syntax you'll need for msgbox).
Excel VBA Arrays: Practical Example of a 2 dimensional array to create a New Workbook.
Excel VBA FIND Function (& how to handle if value NOT found).
Excel ActiveX Combo Box to Select Worksheets with VBA.
Link Page Header to Cell Value with Excel VBA.
Excel VBA: Check If File or Folder Exists (DIR) - Open File or Create Folder.
Reset Dependent Drop-down in Excel (with a tiny bit of VBA).
3 Methods to Unhide All Sheets in Excel (& how to hide).
Free Excel Tool: Unhide Worksheet Utility (select sheets to unhide).
Excel List Box to Display & Print Multiple Sheets as ONE Print Job with VBA.
How to SUM Cells by Color in Excel (Get it to update automatically).
VBA to BROWSE & COPY Data from SELECTED File in Excel.
Get ALL External Links with This SIMPLE Excel TRICK (as NEVER seen before!).
How to create barcodes in Excel that WORK!.
How to Create & Use Excel Macros (Real world example).
Taught by
Leila Gharani
