发帖
雷达卡
by Liaw HockSang (Author)
Visual Basic for Applications (VBA) is the programming language built into Microsoft Office applications (such as Microsoft Excel, Microsoft Word, Microsoft Access, and Microsoft Outlook) to automate various tasks in their own environment and to work with other applications.
This book focuses on VBA in Microsoft Excel for Windows. The discussions in the book are applicable to Excel 2007, Excel 2010, Excel 2013, and Excel 2016, unless otherwise stated. It starts with Chapter 1, which is to get you familiarize with some essential tools that help you to write your VBA programs. Chapter 2 covers the places where you should store your VBA code. Chapter 3 is the fundamentals of programming in VBA. It provides you a quick reference in writing syntax error-free VBA code, in debugging, and in handling errors. Chapter 4 offers some other tips on VBA programming.
This book is for readers that are totally new to Excel VBA, but should have a basic understanding of programming language, such as C or Python. The reader should be an average Excel user who knows, for example, what an array formula is. If you are new to Excel, please teach yourself Excel before exploring the chapters. You may refer to another book written by me entitled Learn Microsoft® Excel® 2010-2016 for Windows® in 24 Hours - A jumpstart to be an intermediate user, which was written for those who are new to Excel.
This book does not serve as a comprehensive reference for intermediate users. Nevertheless, it is a jumpstart for beginners to learn Excel VBA. It is also served as a foundation for my future books and other references that are beyond the reach of beginners.
I hope this book will shorten your time to teach yourself Excel VBA and serve as a quick reference in writing error-free and working VBA programs in realizing your goal. Let Excel VBA work for you.
AZW3/MOBI/EPUB/PDF (conv.) 四种格式压缩包 + supplementary Excel file 压缩包：
本帖隐藏的内容
Learn Excel VBA in 24 Hours.rar
(1.46 MB, 需要: 20 个论坛币)
本附件包括：- Learn Excel(r) VBA in 24 Hours_ - Liaw HockSang.pdf
- Learn Excel(r) VBA in 24 Hours_ - Liaw HockSang.azw3
- Learn Excel(r) VBA in 24 Hours_ - Liaw HockSang.epub
- Learn Excel(r) VBA in 24 Hours_ - Liaw HockSang.mobi
supplementary Excel file.zip
(569.21 KB)
本附件包括：- Chap2_ Click.xlsm
- Chap2_ SelectionChange.xlsm
- Chap2_ UserForm.xlsm
- Chap3.xlsm
- Chap4_Working with arrays.xlsm
- Chap1.xlsm
京公网安备 11010802022788号
