WHO SHOULD READ THIS BOOK?If you want a book that uses a systematic and easy approach, complete with numerous examples and full projects, then this book is for you. The goal of this book is help you how to automate your tasks and create custom applications using VBA programming language without...
show more
WHO SHOULD READ THIS BOOK?If you want a book that uses a systematic and easy approach, complete with numerous examples and full projects, then this book is for you. The goal of this book is help you how to automate your tasks and create custom applications using VBA programming language without thousands of boring pages. This book is a fast lecture, which allows you to start coding since the first chapter. No prior programming knowledge is required. VBA (Visual Basic for Applications) is a programming language developed by Microsoft. It is an awesome resource of Excel and other Office programs. With VBA you can automate tasks and reports in Excel by writing so-called macros, it is also possible develop tools, User Forms, sophisticated applications and a wide variety of professional solutions. The book starts exploring the necessary aspects to master Excel resources with simple codes. These simple commands cover: make selections, do copy and paste, apply number formatting, insert formulas and many other aspects, which has a direct relation between commands and excel interface. With these basic instructions section you are able to automate reports just creating simple routines.In the second part of this lecture, the approach is about VBA programming logic, where is possible to understand the variables, logical statements, repeating cycles, User Forms, and all sorts of advanced resources. In order to facilitate the learning process, the book counts with wide variety of examples to explain each concept including full projects at the end.
show less