LITMIR.BIZ

Скачать книгу

4: Introducing the Excel Object Model Working with the Excel Object Model Diving into Object Properties and Methods Finding Out More from VBA Resources Chapter 5: VBA Sub and Function Procedures Understanding Subs versus Functions Naming Subs and Functions Executing Sub procedures Executing Function Procedures Chapter 6: Using the Excel Macro Recorder Recording Basics Preparing to Record Choosing Between Relative and Absolute Mode Watching the Macro Recorder in Action Specifying Recording Options for Your Macro Streamlining Code Generated by the Macro Recorder

      7  Part 3: Programming Concepts Chapter 7: Essential VBA Language Elements Using Comments in Your VBA Code Using Variables, Constants, and Data Types Using Assignment Statements Working with Arrays Using Labels Chapter 8: Working with Range Objects Referring to Range Objects Referring to a Range Using Properties Working with Range Object Properties Taking Action with Range Object Methods Chapter 9: Using VBA and Worksheet Functions Understanding Functions Using Built-In VBA Functions Using Worksheet Functions in VBA Using Custom Functions Chapter 10: Controlling Program Flow and Making Decisions Going with the Flow, Dude The GoTo Statement Decisions, Decisions Knocking Your Code for a Loop Using For Each-Next Loops with Collections Chapter 11: Automatic Procedures and Events Preparing for the Big Event Knowing Where to Put the Event Code Writing an Event-Handler Procedure Triggering Workbook Events Using Activation Events Programming Worksheet-Related Events Understanding Events Not Associated with Objects Chapter 12: Error-Handling Techniques Types of Errors An Erroneous Macro Example Alternate Ways of Handling Errors Handling Errors: The Details An Intentional Error Chapter 13: Bug Extermination Techniques Species of Bugs Identifying Bugs Debugging Techniques Using the Debugger’s Tools Bug Reduction Tips Chapter 14: VBA Programming Examples Working with Ranges Changing Excel Settings Working with Charts VBA Speed Tips

      8  Part 4: Communicating with Your Users Chapter 15: Simple Dialog Boxes Interacting with the User in VBA Displaying Messages with the MsgBox Function Getting Data with an Input Box Allowing the User to Select a File or Folder Displaying Excel’s Built-In Dialog Boxes Chapter 16: UserForm Basics Knowing When to Use a UserForm Creating UserForms: An Overview Working with UserForms A UserForm Example Chapter

Скачать книгу