Жанры Авторы Контакты О сайте

Книжные новинки Популярные книги

Главная Авторы Michael Alexander Excel 2019 Power Programming with VBA

Читать книгу Excel 2019 Power Programming with VBA - Michael Alexander, Dick Kusleika - Страница 1

Оглавление

Предыдущая Следующая

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 ...202

Оглавление

Excel 2019 Power Programming with VBA

Купить и скачать книгу Вернуться на страницу книги Excel 2019 Power Programming with VBA

Оглавление

Страница 1 Table of Contents List of Tables List of Illustrations Guide Pages Страница 7 Introduction Topics Covered What You Need to Know What You Need to Have Conventions Used in This Book Excel commands Visual Basic Editor commands Keyboard conventions Input VBA code Functions, filenames, and named ranges Typographical conventions Mouse conventions What the Icons Mean NOTE TIP CAUTION ON THE WEB How This Book Is Organized Part I: Introduction to Excel VBA Part II: Advanced VBA Techniques Part III: Working with UserForms Part IV: Developing Excel Applications Part V: Appendix How to Use This Book What's on the Website CHAPTER 1 Essentials of Spreadsheet Application Development IN THIS CHAPTER What Is a Spreadsheet Application? Steps for Application Development Determining User Needs Planning an Application That Meets User Needs NOTE Determining the Most Appropriate User Interface Customizing the Ribbon Customizing shortcut menus Creating shortcut keys Creating custom dialog boxes Using ActiveX controls on a worksheet ON THE WEB Executing the development effort Concerning Yourself with the End User Testing the application What about beta testing? Making the application bulletproof Excel passwords are not foolproof Making the application aesthetically appealing and intuitive Creating a user Help system Documenting the development effort Distributing the application to the user Updating the application when necessary Other Development Issues The user's installed version of Excel Language issues System speed TIP Video modes CHAPTER 2 Introducing Visual Basic for Applications IN THIS CHAPTER Getting a Head Start with the Macro Recorder Creating your first macro NOTE Examining your macro NOTE Testing your macro NOTE Editing your macro Comparing absolute and relative macro recording Recording macros with absolute references NOTE Recording macros with relative references Other macro recording concepts Macro security in Excel Trusted locations Storing macros in your Personal Macro Workbook NOTE Assigning a macro to a button and other form controls NOTE Placing a macro on the Quick Access toolbar Working with the Visual Basic Editor Understanding VBE components Menu bar Toolbar Project window Code window Immediate window Working with the Project window Adding a new VBA module Removing a VBA module NOTE Working with a Code window Minimizing and maximizing windows Getting VBA code into a module TIP Customizing the VBA environment The Editor tab The Editor Format tab The General tab The Docking tab VBA Fundamentals Understanding objects Understanding collections Understanding properties Specifying properties for the active object Understanding methods More about arguments Deep Dive: Working with Range Objects Finding the properties of the Range object The Range property The Cells property NOTE NOTE Getting information from a cell The Offset property Essential Concepts to Remember About the code examples Don't Panic—You Are Not Alone Read the rest of the book Let Excel help write your macro Use the Help system Location matters when asking for help You need to be connected to the Internet Use the Object Browser Pilfer code from the Internet Leverage user forums Visit expert blogs Mine YouTube for video training Learn from the Microsoft Office Dev Center Dissect the other Excel files in your organization Ask your local Excel genius CHAPTER 3 VBA Programming Fundamentals IN THIS CHAPTER VBA Language Elements: An Overview NOTE Entering VBA code Comments TIP Variables, Data Types, and Constants Defining data types NOTE Declaring variables Determining a data type Forcing yourself to declare all variables TIP Scoping variables A note about the examples in this chapter Local variables NOTE CAUTION Module-wide variables Public variables Static variables Working with constants Declaring constants NOTE Using predefined constants NOTE Working with strings Working with dates NOTE About Excel's date bug CAUTION Assignment Statements TIP CAUTION Arrays Declaring arrays TIP Declaring multidimensional arrays Declaring dynamic arrays Object Variables TIP User-Defined Data Types NOTE Built-in Functions TIP The MsgBox function Manipulating Objects and Collections With-End With constructs NOTE For Each-Next constructs NOTE Controlling Code Execution GoTo statements If-Then constructs VBA's IIf function Select Case constructs TIP Looping blocks of instructions For-Next loops What is structured programming? CAUTION NOTE Do While loops NOTE Do Until loops NOTE {buyButton}

Подняться наверх

Популярные жанры Детективы Классика Искусство Психология Наука и образование Фантастика Фэнтези

Книжные новинки Популярные книги Жанры Авторы Контакты О сайте

© КнигаЛит.ру 2015 - 2024. Рейтинг книг, рецензии и отзывы о бумажных и электронных книгах, сравнение цен на книги в магазинах.

На нашем сайте вы можете скачать бесплатно и читать бесплатно онлайн фрагмент интересующего вас произведения, заказать и купить бумажную книгу с доставкой в книжных интернет-магазинах, или электронную книгу в одном из популярных форматов для чтения на ридере, мобильном устройстве и ПК. Подробнее о сайте.