Learning to program in Excel VBA is easy! The Visual Basic programming language is available and waiting in Excel itself - ready to be used. This book will help you utilize the full power of Excel to write and extend macros. It will also allow you to learn to program in Visual Basic - without the expense of buying the Visual Basic software! Its easy, step-by-step, colourful, illustrated approach is ideal for complete beginners or users a little daunted by advanced VBA books. Increase productivity and efficiency with this excellent guide.
This is an older edition (2004) but it was still very helpful in learning the basics. Some of the VBA rules are more implied in the text than explicitly stated but through attempting to create my own and rereading passages.