http://www.loc.gov/mods/v3 http://www.loc.gov/standards/mods/v3/mods-3-2.xsd
Microsoft Excel 2016 Programming by Example
A practical, how-to book on Excel programming, suitable for readers already familiar with the Excel user interface, this book introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. --
Cover -- Title Page -- Copyright -- Contents -- Acknowledgments -- Introduction -- Part I Excel VBA Primer -- Chapter 1 Excel Macros -- A Quick Start in Excel VBA Programming -- Macros and VBA -- Excel Macro-Enabled File Formats -- Macro Security Settings -- Enabling the Developer Tab in Excel -- Hands-On 1.1. Setting Up Excel for Macro Development -- Using The Built-In Macro Recorder -- Planning a Macro -- Hands-On 1.2. Getting Things Ready for Macro Recording -- Recording a Macro -- Hands-On 1.3. Inserting and Naming a Worksheet (Macro Task 1) -- Hands-On 1.4. Inserting Column Headings and Applying Formatting (Macro Task 2) -- Hands-On 1.5. Entering Employee Data (Macro Task 3) -- Hands-On 1.6. Entering Formulas to Fill in Employee First Name (Macro Task 4) -- Hands-On 1.7. Entering Formulas to Fill in Employee Last Name (Macro Task 5) -- Hands-On 1.8. Entering Formulas to Calculate Employee Total Wages (Macro Task 6) -- Hands-On 1.9. Applying Table Format (Macro Task 7) -- Editing Recorded Macros -- Hands-On 1.10. Examining the Macro Code -- Macro Comments -- Hands-On 1.11. Adding Comments to the Macro Code -- Cleaning Up the Macro Code -- Hands-On 1.12. Cleaning Up the Macro Code -- Running a Macro -- Hands-On 1.13. Running a Macro Using the Macro Dialog Box -- Testing and Debugging a Macro -- Hands-On 1.14. Running a Macro from the VBE Screen -- Saving and Renaming a Macro -- Hands-On 1.15. Saving Macros and Running Macros from Another Workbook -- Printing Macro Code -- Hands-On 1.16. Printing Macro Code -- Improving Your Recorded Macros -- Hands-On 1.17. Adding Visual Basic Statements to the Recorded Macro Code -- Creating a Master Macro -- Hands-On 1.18. Creating a Master Macro Procedure -- Various Methods Of Running Macros -- Running the Macro Using a Keyboard Shortcut -- Hands-On 1.19. Assigning a Macro to a Keyboard shortcut.
Running the Macro from the Quick Access Toolbar -- Hands-On 1.20. Running a Macro from the Quick Access Toolbar -- Running the Macro from a Worksheet Button -- Hands-On 1.21. Running a Macro from a Button Placed on a Worksheet -- Summary -- Chapter 2 Excel Programming Environment -- A Quick Overview of Its Tools and Features -- Understanding the Project Explorer Window -- Understanding the Properties Window -- Understanding the Code Window -- Setting the VBE Options -- Syntax and Programming Assistance -- List Properties/Methods -- List Constants -- Parameter Info -- Quick Info -- Complete Word -- Indent/Outdent -- Hands-On 2.1. Indenting/Outdenting Visual Basic Code -- Comment Block/Uncomment Block -- Using The Object Browser -- Hands-On 2.2. Writing a VBA Procedure to Move a Text Box on the Worksheet -- Hands-On 2.3. Writing a VBA Procedure to Move a Circle on the Worksheet -- Locating Procedures with the Object Browser -- Hands-On 2.4. Using Object Browser to Locate VBA Procedures -- Using the VBA Object Library -- Hands-On 2.5. Writing a VBA Procedure to Create a Folder in Windows -- Using the Immediate Window -- Hands-On 2.6. Entering and Executing VBA Statements in the Immediate Window -- Obtaining Information in the Immediate Window -- Hands-On 2.7. Obtaining Information in the Immediate Window -- Working with Worksheet Cells and Ranges -- Using the Range Property -- Hands-On 2.8. Practice Using the Range Property to Select Worksheet Cells -- Using the Cells Property -- Hands-On 2.9. Practice Using the Cells Property to Select Worksheet Cells (Part I) -- Hands-On 2.10. Practice Using the Cells Property to Select Worksheet Cells (Part II) -- Using the Offset Property -- Hands-On 2.11. Selecting Cells Using the Offset Property -- Using the Resize Property -- Hands-On 2.12. Writing a VBA Statement to Resize a Selection of Cells.
Using the End Property -- Hands-On 2.13. Selecting Cells Using the End Property -- Moving, Copying, and Deleting Cells -- Hands-On 2.14. Moving, Copying, and Deleting Cells -- Working with Rows and Columns -- Hands-On 2.15. Selecting Entire Rows and Columns -- Obtaining Information about the Worksheet -- Hands-On 2.16. Counting Rows and Columns -- Entering Data and Formatting Cells -- Hands-On 2.17. Using VBA Statements to Enter Data in a Worksheet -- Returning Information Entered in a Worksheet -- Finding Out about Cell Formatting -- Working with Workbooks and Worksheets -- Hands-On 2.18. Working with Workbooks -- Hands-On 2.19. Working with Worksheets -- Working with Windows -- Hands-On 2.20. Working with Windows -- Working with the Excel Application -- Hands-On 2.21. Working with the Excel Application -- Summary -- Chapter 3 Excel VBA Fundamentals -- A Quick Reference to Writing VBA Code -- Excel Objects,Properties, and Methods -- Microsoft Excel Object Model -- Writing Simple and Complex VBA Statements -- Breaking Up Long VBA Statements -- Saving Results of VBA Statements -- Introducing Data Types -- Using Variables -- How to Create Variables -- How to Declare Variables -- Specifying the Data Type of a Variable -- Assigning Values to Variables -- Hands-On 3.1. Writing a VBA Procedure with Variables -- Forcing Declaration of Variables -- Hands-On 3.2. Writing a VBA Procedure with Explicitly Declared Variables -- Understanding the Scope of Variables -- Procedure-Level (Local) Variables -- Module-Level Variables -- Hands-On 3.3. Writing a VBA Procedure with a Module-Level Variable -- Project-Level Variables -- Lifetime of Variables -- Finding a Variable Definition -- Determining a Data Type of a Variable -- Hands-On 3.4. Using the Built-In VarType Function -- Using Constants -- Built-In Constants.
Hands-On 3.5. Viewing Excel Constants in the Object Browser -- Converting between Data Types -- Hands-On 3.6. Using Data Type Conversion Functions in VBA -- Hands-On 3.7. Writing a VBA Procedure with a Static Variable -- Using Object Variables in VBA Procedures -- Hands-On 3.8. Writing a VBA Procedure with Object Variables -- Using Specific Object Variables -- Summary -- Chapter 4 Excel VBA Procedures -- A Quick Guide to Writing Function Procedures -- Understanding Function Procedures -- Creating a Function Procedure -- Hands-On 4.1. Writing a Simple Function Procedure -- Various Methods of Running Function Procedures -- Running a Function Procedure from a Worksheet -- Hands-On 4.2. Executing a Function Procedure from within an Excel Worksheet -- Running a Function Procedure from Another VBA Procedure -- Hands-On 4.3. Executing a Function from a VBA Procedure -- Ensuring Availability of Your Custom Functions -- Passing Arguments to Function Procedures -- Hands-On 4.4. Passing Arguments to Functions (Example 1) -- Specifying Argument Types -- Hands-On 4.5. Passing Arguments to Functions (Example 2) -- Passing Arguments by Reference and Value -- Hands-On 4.6. Passing Arguments to Functions (Example 3) -- Using Optional Arguments -- Hands-On 4.7. Writing Functions with Optional Arguments -- Testing a Function Procedure -- Locating Built-In Functions -- Getting to Know the MsgBox Function -- Hands-On 4.8. Formatting Text for Display in the MsgBox Function -- Hands-On 4.9. Using the MsgBox Function with Arguments (Example 1) -- Hands-On 4.10. Using the MsgBox Function with Arguments (Example 2) -- Returning Values from the MsgBox Function -- Hands-On 4.11. Using the MsgBox Function with Arguments (Example 3) -- Getting to Know the InputBox Function -- Hands-On 4.12. Using the InputBox Function (Example 1) -- Determining and Converting Data Types.
Hands-On 4.13. Using the InputBox Function (Example 2) -- Using the InputBox Method -- Hands-On 4.14. Using the Excel InputBox Method -- Summary -- Chapter 5 Adding Decisions to Excel VBA Programs -- A Quick Introduction to Conditional Statements -- Relational and Logical Operators -- Using If...Then Statement -- Hands-On 5.1. Evaluating Conditions in the Immediate Window -- Hands-On 5.2. Writing a VBA Procedure with a Simple If...Then Statement -- Using If...Then...Else Statement -- Hands-On 5.3. Writing a VBA Procedure with an If Then...Else Statement -- Using If...Then...ElseIf Statement -- Hands-On 5.4. Writing a VBA Procedure with an If...Then...ElseIf Statement -- Nested If...Then Statements -- Using the Select Case Statement -- Hands-On 5.5. Writing a VBA Procedure with a Select Case Statement -- Using Is with the Case Clause -- Specifying a Range of Values in a Case Clause -- Specifying Multiple Expressions in a Case Clause -- Writing a VBA Procedure with Multiple Conditions -- Hands-On 5.6. Writing a VBA Procedure with Multiple Conditions -- Using Conditional Logic in Function Procedures -- Hands-On 5.7. Writing a Function Procedure with a Select Case Statement -- Summary -- Chapter 6 Adding Repeating Actions to Excel VBA Programs -- A Quick Introduction to Looping Statements -- Introducing Looping Statements -- Understanding Do...While and Do...Until Loops -- Hands-On 6.1. Writing a VBA Procedure with a Do... While Statement -- Hands-On 6.2. Writing a VBA Procedure with a Do... Until Statement -- Avoiding Infinite Loops -- Executing a Procedure Line by Line -- Hands-On 6.3. Executing a Procedure Line by Line -- Understanding While...Wend Loop -- Hands-On 6.4. Writing a VBA Procedure with a While... Wend Statement -- Understanding For...Next Loop -- Hands-On 6.5. Writing a VBA Procedure with a For... Next Statement -- Understanding For...Each...Next Loop.
Plný text je dostupný pouze z IP adres počítačů Univerzity Tomáše Bati ve Zlíně nebo vzdáleným přístupem pro zaměstnance a studenty
Dulles, Virginia : Mercury Learning and Information, 2017