VBA TUTOR LESSONSHomeNewsletter Issues The home of 'VBA Tutor'The internets #1 VBA Tutorial - Reorganised & Updated for latest OFFICE versions |
|
|
VBA TUTOR PART ONE ~ |
| Shows how to use VBA [Visual Basic for Applications] with OFFICE 2003 ( VBATutor 2007 ) & OFFICE 2007 ( VBATutor 2008 ). It is designed to be used by those who have had no previous computer programming experience. |
| Try Lessons 1 to 5 of VBATutor 2007 online for FREE! |
VBA TUTOR PART TWO ~ |
| Shows how to collect, save, organize and use data. It is designed for those that have worked through Part One or have previous programming experience. |
| Look at VBATutor 2007 Part TWO Overview ONLINE! |
VBA TUTOR PART THREE ~ |
| Looks at more advanced topics such as Searching, Sorting and Filtering data, writing to and reading from comma delimited text files and EXCEL files, going on to look at some more advanced userforms. The coding in Part Three is more advanced and no help is given for the exercises. |
| Look at VBATutor 2007 Part Three Overview ONLINE! |
VBA TUTOR PART FOUR ~ |
| Investigates the use of Dynamic MultiDimentioned Arrays, Object Arrays, Collections, Events, and finishes with a look at using macros in EXCEL. The coding in Part Four is more advanced and only a little help is given for the exercises. A TicTacToe and a Hangman game are included as examples for the code. |
| Look at VBATutor 2007 Part Four Overview ONLINE! |
VBA TUTOR PART FIVE ~ |
| Looks at modules, classes and scope, exporting and importing modules and forms, concentrating on using the MAPI API to incorporate e-mail capabilities into WORD and EXCEL. Learn how to automatically send emails formatted and addressed using data in your OFFICE programs with no user input! |
| Look at VBATutor 2007 Part Five Overview ONLINE! |
NOTE: You must have MS OFFICE '97 or later installed to read the tutorial documents and to program with VBA. |
© 2007 Gary Radley Lily's Jewellery VBA Help Tutor for Office 2003 / 2007 Word and Excel. Help and lessons with VBA macros and automation. VBA help for word, excel and access, with a tutor to learn with tutorials and lesson and lessons. The excel lessons for VB and Visual word Basic, includes macro and macros with automation addin or addins for Office 2003 & 2007 and word, excel, XP, and VBA Mischief Motivation Attitude |