Harker M. VBA - Turning to the Dark Side of Excel

Amazon, 2020. - 235p. - ASIN: B089DL4FHKAimed at complete beginners and novices in Excel VBA programming, this book will take you from the very basics through to working with other applications in the Microsoft suite. Starting with basic navigation, you will be taken through a training program based on over ten years of running VBA training courses to people of all ages, backgrounds and industries. Each chapter will add more complexity and options to your code writing, including loops, variables, arrays and the object model. Most sections have structured exercises so you can practice what you have learnt, with sample answers at the back so you can compare your answers, or simply see a way of dealing with the questions. The answers contain additional notes and comments to help you understand better why a particular method has been applied, and where applicable, explanations about where you might have been caught out. Not having a programming background, I have tried to keep explanations and terms as simple and as clear as possible so that you can understand it all without the need to decipher the text before you can even start understanding what is going on in terms of code. By the end of the book you should be in a position to automate many of your standard daily tasks involving Excel and hopefully give you the confidence and knowledge to move on to bigger projects.