This course on Excel VBA and Macros teaches learners how to get started with VBA in Excel. By the end of the course, students will be able to:
- Use the macro recorder and the visual basic editor
- Understand objects, properties, and methods in VBA
- Refer to ranges and write to cells effectively
- Copy and paste data using VBA
- Create loops and use the message box in VBA
The course employs a tutorial-based teaching method and is designed for beginners looking to enhance their Excel skills with VBA and macros.
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
