EXCEL VBA Programming By Examples: Programming For Complete Beginners, Step-By-Step Illustrated Guide to Mastering Excel VBA

✍ Scribed by Thanh Tran

• Publisher: Thanh Tran
• Year: 2019
• Tongue: English
• Leaves: 269
• Edition: Kindle Edition
• Category: Library

✦ Synopsis

You need to understand and implement the power of Visual Basic for Applications (VBA).
You’ll find an overview of the essential elements and concepts for programming with Excel. You’ll discover techniques for handling errors and exterminating bugs, working with range objects and controlling program flow, and much more.....

Whether you have never created a program with Visual Basic Application or you're looking to learn some new tricks, then this book is for you!Containing 16 chapters full of information, definitions, and step-by-step instructions to create your own programs, this book will help you master VBA Programming.

✦ Table of Contents

Table of Contents:

Chapter 1. Create a Macro
Chapter 2. MsgBox
Chapter 3. Workbook and Worksheet Object
Chapter 4. Range Object
Chapter 5. Variables
Chapter 6. If Then Statement
Chapter 7. Loop
Chapter 8. Macro Errors
Chapter 9. String Manipulation
Chapter 10. Date and Time
Chapter 11. Events
Chapter 12. Array
Chapter 13. Function and Sub
Chapter 14. Application Object
Chapter 15. ActiveX Controls
Chapter 16. Userform