| SETTING UP ENVIRONMENT | Setting up VBA IDE Interactive Development Environment |
| Saving as Macro Enabled workbook - 2 types | |
| Personal Macro Workbook | |
| Recording Macro - 2 windows | |
| WRITING FIRST CODE | Writing first code |
| Where to save - Module, Sheet, Workbook | |
| Declaration | |
| Option Explicit | |
| Comment and Indent | |
| Variable Types | |
| Intellisense | |
| EXAMPLES | Examples: |
| Sheet - Go to Specific Cell | |
| Workbook - Greeting | |
| TYPES OF REFERENCES | Absolute vs Relative |
| What can / cannot be recorded | |
| Assign to buttons - conditional formatting Top 3 Bottom 3 | |
| Assign to buttons - present a dashboard | |
| EXAMPLES | How to Search online - Dos and Donts |
| Breaking down the code - Table of Content | |
| Breaking down the code - Unhide all Sheets | |
| Breaking down the code - List all Files in a Folder | |
| Breaking down the code - Delete Blank Rows | |
| CREATE FUNCTIONS | Create UDF - user defined function |
| EXAMPLES | Create UserForm |
| Connect UserForm to Cells |
Practical Learning
Practice Sheets
Recording
Certification by Edu4Sure
Any Payment Method (Please pay as per discussion with the team for the required course)
1) Net Banking
TestFormula Education Pvt. Ltd.
Account Number: 33729473635
State Bank of India, Delhi
IFSC: SBIN0001573
2) Pay through Payment Gateway (International transactions acceptable)