VBA TUTOR 2007 Part One Introduction: Welcome to 'VBATUTOR 2007'! Index PageLesson 1

The following lessons and included example files have been carefully written and refined over the last seven years so that anyone, even those with little or no previous computer programming experience, can learn how to use VBA to program both WORD and EXCEL. For you to be successful .... the pre-requirement is to have the desire to learn. the lesson requirement is to be patient. the post-requirement is to practice what you have learnt. The concept behind these lessons is to learn 'progressively', to start with the 'basic' concepts, then progress on to more 'advanced' concepts. For example, a lot of the examples and exercises in Part One do not have a lot of use in a "real world" VBA project, such as using a 'CommandButton' in a WORD Document, but the skills and knowledge learnt will have a lot of relevance when we go on to work with 'UserForms' in more advanced lessons. What I have attempted to do, to aid learning, is to simplify the example code and explanations used in these lessons down to the basics. This has meant that some of the example code is not 'good programming'. That is because I am not trying to show you how well ' I ' can code in VBA, I am trying to show ' YOU ' how to code in VBA. As you progress through the lessons, you will be introduced to the 'advanced concepts' of good programming, concepts such as .... Error trapping Modular Programming Using Objects, including Object Properties, Object Arrays and Object Collections Note: The included exercise and help files are contained in 'zip' files, that can be accessed throughout the lessons where appropriate. These must be unzipped to create a 'Working Directory' for each section of these tutorials. The location of the 'Working Folder' for 'PART 1', should be "C:\Documents and Settings\?yourname?\My Documents\Unzipped\vbakit1", where '?yourname?' should be your computers 'user account' name. I hope you find 'VBATutor 2007' to be both helpful and practical. HAPPY LEARNING! Gary Radley [VBATutor 2007 Author] These lessons refer to examples that can be downloaded from here!

Index PageLesson 1 © 2007 Gary Radley