책 이미지
책 정보
· 분류 : 외국도서 > 컴퓨터 > 데스크탑 애플리케이션 > 스프레드시트
· ISBN : 9781119077398
· 쪽수 : 408쪽
· 출판일 : 2015-10-12
목차
Introduction 1
Part I: Getting Started with Excel VBA Programming 7
Chapter 1: What Is VBA? 9
Chapter 2: Jumping Right In 19
Part II: How VBA Works with Excel 29
Chapter 3: Working in the Visual Basic Editor 31
Chapter 4: Introducing the Excel Object Model 51
Chapter 5: VBA Sub and Function Procedures 65
Chapter 6: Using the Excel Macro Recorder 79
Part III: Programming Concepts 91
Chapter 7: Essential VBA Language Elements 93
Chapter 8: Working with Range Objects 115
Chapter 9: Using VBA and Worksheet Functions 131
Chapter 10: Controlling Program Flow and Making Decisions 145
Chapter 11: Automatic Procedures and Events 165
Chapter 12: Error‐Handling Techniques 187
Chapter 13: Bug Extermination Techniques 201
Chapter 14: VBA Programming Examples 215
Part IV: Communicating with Your Users 237
Chapter 15: Simple Dialog Boxes 239
Chapter 16: UserForm Basics 257
Chapter 17: Using UserForm Controls 275
Chapter 18: UserForm Techniques and Tricks 295
Chapter 19: Accessing Your Macros through the User Interface 321
Part V: Putting It All Together 333
Chapter 20: Creating Worksheet Functions — and Living to Tell about It 335
Chapter 21: Creating Excel Add-Ins 353
Part VI: The Part of Tens 365
Chapter 22: Ten VBA Questions (and Answers) 367
Chapter 23: (Almost) Ten Excel Resources 371
Chapter 24: Ten VBA Do’s and Don’ts 375
Index 381
