VBA TUTOR LESSONS

HomeVBA TutorBuy VBA Tutor 2007/2008VBA TutorFREE Demo DownloadVBA TutorFree Online Lessons
Newsletter IssuesVBA TutorNewsletter TutorialsVBA TutorTrial SoftwareVBA TutorExcel Add-Ins

The home of 'VBA TUTOR'

The internets #1 VBA Tutorial - Reorganised & Updated for OFFICE versions 2003 & 2007
Find out more ...
Google

PART ONE:

The lessons in Part One refer to exercises that can be downloaded here!

Note [1] ~ ALL files MUST be unzipped into a working directory to work properly

Note [2] ~ These FREE demo files are for OFFICE version 2003 or lower
INTRODUCTION: WELCOME!      Demo Only!
Lesson 1: Using the VB Editor      Demo Only!
Lesson 2: VBA Structure      Demo Only!
Lesson 3: VBA Control Structures      Demo Only!
Lesson 4: Using Variables      Demo Only!
Lesson 5: Having a bit of fun :)      Demo Only!
Lesson 6: Using / Accessing VBA Code  
Lesson 7: 'Modules' and 'Scope'  
Lesson 8: Branching and Trapping Errors  
Lesson 9: Objects and Properties  

PART TWO:

The lessons in Part Two refer to exercises that can be downloaded here!
INTRODUCTION: INTERMEDIATE LESSONS      Demo Only!
Lesson 10: Organizing Data - Arrays  
Lesson 11: String Manipulation  
Lesson 12: Maths Operators  
Lesson 13: Passing Arguments  
Lesson 14: Controls and Forms  
Lesson 15: Saving Data in Tables  
Lesson 16: Introducing some programming style  
Lesson 17: Efficient and robust computer programming  

PART THREE:

The lessons in Part Three refer to exercises that can be downloaded here!
INTRODUCTION: ADVANCED SKILLS      Demo Only!
Lesson 18: Debugging your VBA Projects  
Lesson 19: Sorting data in tables  
Lesson 20: Searching/Filtering data in tables  
Lesson 21: Writing data to/from text files  
Lesson 22: Using DDE ~ Writing data to EXCEL  
Lesson 23: Using forms in EXCEL  
Lesson 24: Advanced userforms  
Lesson 25: Using OLE instead of DDE  

PART FOUR:

The lessons in Part Four refer to exercises that can be downloaded here!
INTRODUCTION: Lets have some fun!      Demo Only!
Lesson 26: Dynamic Arrays  
Lesson 27: Object Arrays  
Lesson 28: 'Case' and 'Random Numbers' Revisited  
Lesson 29: Using Collections  
Lesson 30: The best teacher!  
Lesson 31: An 'EXCEL'LENT Exercise  
Lesson 32: Introduction to 'Events'  
Lesson 33: Events  

PART FIVE:
INTRODUCTION: Lets get serious!      Demo Only!
Lesson 34: Creating and Using Add-ins  
Lesson 35: Reusing Modules and Forms  
Lesson 36: Using EMail in WORD and EXCEL  
Lesson 37: A VBA Showbag of Tips and Tricks  
Lesson 38: Using 'VBA' in other OFFICE Applications  
Lesson 39: Links to advanced topics  
Lesson 40: Conclusion! The END  


HomeVBA TutorBuy VBA Tutor 2007/2008VBA TutorDemo DownloadVBA TutorFree Lessons
Newsletter IssuesVBA TutorNewsletter TutorialsVBA TutorTrial SoftwareVBA TutorCosting Add-InVBA Tutor Excel Add-Ins

© 2007 Gary Radley
Lily's Jewellery