Scribd
Upload
358 views

Unlock Excel VBA and Excel Macros

The document covers various topics related to macros and VBA in Microsoft Excel. It begins with an introduction to macros and the Visual Basic Editor. It then discusses recording a basic macro, different ways to run macros, and the difference between macros and VBA. The document is divided into multiple sections that cover various aspects of VBA programming like referencing ranges, working with variables and loops, debugging code, and interacting with other Office applications. It includes examples like automating a table of contents, sales reporting tool, and invoice generation tool. The document aims to teach the fundamentals of VBA.

Uploaded by

SDE CSC MAVELIKARA
Copyright
© © All Rights Reserved
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
358 views

Unlock Excel VBA and Excel Macros

The document covers various topics related to macros and VBA in Microsoft Excel. It begins with an introduction to macros and the Visual Basic Editor. It then discusses recording a basic macro, different ways to run macros, and the difference between macros and VBA. The document is divided into multiple sections that cover various aspects of VBA programming like referencing ranges, working with variables and loops, debugging code, and interacting with other Office applications. It includes examples like automating a table of contents, sales reporting tool, and invoice generation tool. The document aims to teach the fundamentals of VBA.

Uploaded by

SDE CSC MAVELIKARA
Copyright
© © All Rights Reserved
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Section 1: Introduction & Scope

Section 2: Your First Macro

6. Overview: Macros & Visual Basic Editor (VBE)

 Alt + T + M + R - record macro

7. Steps to Your First Macro Recording

8. Visual Basic Editor: What You Need to Know

 Alt + F11 -- opens the VBE.

9. Project: Dynamic Cell Selection (Special Cells) - Perfect for Flexible Macros

10. Project: Copy (Consolidate) Data - Absolute versus Relative Macro Recording

11. 7 Ways to Run Macros / VBA code (incl. creative & modern buttons)

12. OFFICE 365 Update: Change from Excel Comments to Notes

13. Activity: Record a Macro that Deletes all Comments

14. What's the Difference Between Macros and VBA?

Section 3: The Object Model

Section 4: Referencing Ranges, Worksheets & Workbooks with VBA

Section 5: Working with Variables

Section 6: Looping through Collections & Making Decisions

Section 7: Useful Built-in Functions

Section 8: Debugging, Error Handling & Procedure Scope

Section 9: Main Project #1: Create a Tool to Automate Table of Contents

Section 10: Looping in VBA (Controlling the Flow of Code)

Section 11: Working with Arrays

Section 12: Working with Files, Folders & Text Files

Section 13: Excel Tables, Formulas & Pivot Tables

Section 14: Main Project #2: Sales Regional Reporting Tool

Section 15: Interacting with Other Applications (Word, PowerPointetc.)

Section 16: Workbook and Worksheet Events

Section 17: Working with Userforms & ActiveX Controls

Section 18: Main Project #3: Invoice Generation Tool

Section 19: Create your own Custom Functions

Section 20: Working with Charts


Section 21: Summary & Final Words

You might also like