Excel programming your visual blueprint for creating interactive spreadsheets
A great guide to Excel programming that is perfect for visual learners and takes you beyond Excel basics! This book is the perfect reference for Excel users who want to delve deeper into the application to create powerful and dynamic programs. From creating macros to customizing dialog boxes, this s...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
New York, NY :
Hungry Minds
c2010.
|
| Edición: | 3rd ed |
| Colección: | Visual read less, learn more.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628428406719 |
Tabla de Contenidos:
- Excel® Programming: Your visual blueprintTM for creating interactive spreadsheets, 3rd Edition; TABLE OF CONTENTS; Chapter 1: USING MACROS AND FORM CONTROLS; Introducing Excel Programming; Introducing Macros; Set Macro Security; Create a Digital Signature; Record a Macro; Assign a Digital Signature to a Macro; Run a Macro; Create and Launch a Keyboard Shortcut; Assign a Macro to the Quick Access Toolbar; Delete a Macro; Add a Form Control to a Worksheet; Assign Values to a Form Control; Add a Macro to a Form Control; Chapter 2: USING THE VISUAL BASIC EDITOR; Introducing the Visual Basic Editor
- Activate the Visual Basic EditorOpen Visual Basic Editor Windows; Set Properties for a Project; Set Display Options for the Code Window; Add a New Module; Remove a Module; Hide a Macro; Update a Macro; Chapter 3: INTRODUCING VISUAL BASIC FOR APPLICATIONS; Create Sub Procedures; Create Functions; Comment Your Code; Reference Cells and Ranges; Understanding Variables and Data Types; Declare Variables; Work with Strings; Work with Numbers; Create a Constant; Chapter 4: INTRODUCING THE EXCEL OBJECT MODEL; Discover the Excel Object Model; Access the Excel Object Model Reference
- Create an Object VariableChange the Properties of an Object; Compare Object Variables; Using an Object Method; Display a Built-in Dialog Box; Chapter 5: UNDERSTANDING ARRAYS; Declare an Array; Declare a Multidimensional Array; Convert a List to an Array; Redimension an Array; Create a User-Defined Data Type; Chapter 6: CONTROLLING PROGRAM FLOW; Create Comparisons; Make Use of Logical Operators; Employ Do While Loops; Create Do Until Loops; Create For Next Loops; Execute For Each In Loops; Create If Then Else Statements; Construct Select Case Statements; GoTo a Named Location; Call a Procedure
- Chapter 7: USING EXCEL WORKSHEET FUNCTIONSWork with Excel Worksheet Functions; Work with a MsgBox Function; Using the InputBox Function; Retrieve the Current Date and Time; Perform Date and Time Calculations; Format a Date Expression; Format a Numeric Expression; Change the Case of a String; Return a Portion of a String; Chapter 8: DEBUGGING MACROS; Debug a Procedure with Inserted Breakpoints; Using the Watches Window to Debug a Procedure; Step through a Procedure; Using the Immediate Window; Resume Execution When an Error Is Encountered; Process a Runtime Error
- Chapter 9: WORKING WITH WORKBOOKS AND FILESOpen a Workbook; Open a Text File as a Workbook; Open a File Requested by the User; Save a Workbook; Save a Workbook in a Format Specified by the User; Determine if a Workbook Is Open; Close a Workbook; Create a New Workbook; Delete a File; Chapter 10: WORKING WITH WORKSHEETS; Add a Sheet; Delete a Sheet; Move a Sheet; Copy a Sheet; Hide a Sheet; Change the Name of a Sheet; Save a Sheet to Another File; Protect a Worksheet; Protect a Chart; Print a Sheet; Sort Sheets by Name; Chapter 11: DEFINING RANGES; Using the Range Property
- Using the Cells Property
