Excel 2003 VBA programmer's reference [[electronic resource] /] / Paul Kimmel ... [et al.] |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, IN., : Wiley Pub., c2004 |
Descrizione fisica | 1 online resource (1176 p.) |
Disciplina | 005.54 |
Altri autori (Persone) | KimmelPaul |
Collana | Programmer to programmer |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets Computer software - Development |
Soggetto genere / forma | Electronic books. |
ISBN |
1-280-26598-1
9786610265985 0-7645-7898-7 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
About the Authors; Acknowledgments; Introduction; Chapter 1: Primer in Excel VBA; Using the Macro Recorder; Recording Macros; Running Macros; The Visual Basic Editor; Other Ways to Run Macros; User Defined Functions; Creating a UDF; What UDFs Cannot Do; The Excel Object Model; Objects; Getting Help; Experimenting in the Immediate Window; The VBA Language; Basic Input and Output; Calling Functions and Subroutines; Variable Declaration; Scope and Lifetime of Variables; Variable Type; Object Variables; Making Decisions; Looping; Arrays; Runtime Error Handling; Summary
Chapter 2: Programming in the VBEWriting Code; Programming for People; Writing Code; Where Does My Code Go?; Managing a Project; Adding Classes; Modifying Properties; Importing and Exporting Visual Basic Code; Editing; Managing Editor Options; Running and Debugging Code; Using Watches; Using the Object Browser; Summary; Chapter 3: The Application Object; Globals; The Active Properties; Display Alerts; Screen Updating; Evaluate; InputBox; StatusBar; SendKeys; OnTime; OnKey; Worksheet Functions; Caller; Summary; Chapter 4: Object-Oriented Theory and VBA; Comparing Classes and Interfaces Defining an InterfaceImplementing an Interface; Defining Methods; Parameters; Implementing Recursive Methods; Eliminating Recursion with Loops; Defining Fields; Defining Properties; Defining Events; Defining Events in Classes; Raising Events; Handling Events; Information Hiding and Access Modifiers; Encapsulation, Aggregation, and References; Summary; Chapter 5: Event Procedures; Worksheet Events; Enable Events; Worksheet Calculate; Chart Events; Before Double Click; Workbook Events; Save Changes; Headers and Footers; Summary; Chapter 6: Class Modules; Creating Your Own Objects Using CollectionsClass Module Collection; Trapping Application Events; Embedded Chart Events; A Collection of UserForm Controls; Referencing Classes Across Projects; Summary; Chapter 7: Writing Bulletproof Code; Using Debug.Print; Using Debug.Assert; A Brief Exemplar of PC Debugging; Creating Reusable Tools with the Debug Object; Tracing Code Execution; Trapping Code Execution Paths; Asserting Application Invariants; Raising Errors; Writing Error Handlers; On Error Goto Line Number; On Error Resume Next; On Error GoTo 0; Using the Err Object; Scaffolding; Writing to the EventLog; Summary Chapter 8: Debugging and TestingStepping Through Code; Running Your Code; Stepping into Your Code; Step Over; Step Out; Run to Cursor; Set Next Statement; Show Next Statement; Using Breakpoints; Using Watches; Add Watch; Edit Watch; Quick Watch; Locals Windows; Testing an Expression in the Immediate Window; Resources for Finding Definitions; Edit => Quick Info; Edit => Parameter Info; Edit => Complete Word; Edit => List Properties/Methods; Edit => List Constants; Edit => Bookmarks; View => Definition; View => Object Browser; Viewing the Call Stack; Asserting Application Invariants; Summary Chapter 9: UserForms |
Record Nr. | UNINA-9910449940303321 |
Indianapolis, IN., : Wiley Pub., c2004 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel 2003 VBA programmer's reference [[electronic resource] /] / Paul Kimmel ... [et al.] |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, IN., : Wiley Pub., c2004 |
Descrizione fisica | 1 online resource (1176 p.) |
Disciplina | 005.54 |
Altri autori (Persone) | KimmelPaul |
Collana | Programmer to programmer |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets Computer software - Development |
ISBN |
1-280-26598-1
9786610265985 0-7645-7898-7 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
About the Authors; Acknowledgments; Introduction; Chapter 1: Primer in Excel VBA; Using the Macro Recorder; Recording Macros; Running Macros; The Visual Basic Editor; Other Ways to Run Macros; User Defined Functions; Creating a UDF; What UDFs Cannot Do; The Excel Object Model; Objects; Getting Help; Experimenting in the Immediate Window; The VBA Language; Basic Input and Output; Calling Functions and Subroutines; Variable Declaration; Scope and Lifetime of Variables; Variable Type; Object Variables; Making Decisions; Looping; Arrays; Runtime Error Handling; Summary
Chapter 2: Programming in the VBEWriting Code; Programming for People; Writing Code; Where Does My Code Go?; Managing a Project; Adding Classes; Modifying Properties; Importing and Exporting Visual Basic Code; Editing; Managing Editor Options; Running and Debugging Code; Using Watches; Using the Object Browser; Summary; Chapter 3: The Application Object; Globals; The Active Properties; Display Alerts; Screen Updating; Evaluate; InputBox; StatusBar; SendKeys; OnTime; OnKey; Worksheet Functions; Caller; Summary; Chapter 4: Object-Oriented Theory and VBA; Comparing Classes and Interfaces Defining an InterfaceImplementing an Interface; Defining Methods; Parameters; Implementing Recursive Methods; Eliminating Recursion with Loops; Defining Fields; Defining Properties; Defining Events; Defining Events in Classes; Raising Events; Handling Events; Information Hiding and Access Modifiers; Encapsulation, Aggregation, and References; Summary; Chapter 5: Event Procedures; Worksheet Events; Enable Events; Worksheet Calculate; Chart Events; Before Double Click; Workbook Events; Save Changes; Headers and Footers; Summary; Chapter 6: Class Modules; Creating Your Own Objects Using CollectionsClass Module Collection; Trapping Application Events; Embedded Chart Events; A Collection of UserForm Controls; Referencing Classes Across Projects; Summary; Chapter 7: Writing Bulletproof Code; Using Debug.Print; Using Debug.Assert; A Brief Exemplar of PC Debugging; Creating Reusable Tools with the Debug Object; Tracing Code Execution; Trapping Code Execution Paths; Asserting Application Invariants; Raising Errors; Writing Error Handlers; On Error Goto Line Number; On Error Resume Next; On Error GoTo 0; Using the Err Object; Scaffolding; Writing to the EventLog; Summary Chapter 8: Debugging and TestingStepping Through Code; Running Your Code; Stepping into Your Code; Step Over; Step Out; Run to Cursor; Set Next Statement; Show Next Statement; Using Breakpoints; Using Watches; Add Watch; Edit Watch; Quick Watch; Locals Windows; Testing an Expression in the Immediate Window; Resources for Finding Definitions; Edit => Quick Info; Edit => Parameter Info; Edit => Complete Word; Edit => List Properties/Methods; Edit => List Constants; Edit => Bookmarks; View => Definition; View => Object Browser; Viewing the Call Stack; Asserting Application Invariants; Summary Chapter 9: UserForms |
Record Nr. | UNINA-9910783278403321 |
Indianapolis, IN., : Wiley Pub., c2004 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel 2003 VBA programmer's reference / / Paul Kimmel ... [et al.] |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, IN., : Wiley Pub., c2004 |
Descrizione fisica | 1 online resource (1176 p.) |
Disciplina | 005.54 |
Altri autori (Persone) | KimmelPaul |
Collana | Programmer to programmer |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets Computer software - Development |
ISBN |
1-280-26598-1
9786610265985 0-7645-7898-7 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
About the Authors; Acknowledgments; Introduction; Chapter 1: Primer in Excel VBA; Using the Macro Recorder; Recording Macros; Running Macros; The Visual Basic Editor; Other Ways to Run Macros; User Defined Functions; Creating a UDF; What UDFs Cannot Do; The Excel Object Model; Objects; Getting Help; Experimenting in the Immediate Window; The VBA Language; Basic Input and Output; Calling Functions and Subroutines; Variable Declaration; Scope and Lifetime of Variables; Variable Type; Object Variables; Making Decisions; Looping; Arrays; Runtime Error Handling; Summary
Chapter 2: Programming in the VBEWriting Code; Programming for People; Writing Code; Where Does My Code Go?; Managing a Project; Adding Classes; Modifying Properties; Importing and Exporting Visual Basic Code; Editing; Managing Editor Options; Running and Debugging Code; Using Watches; Using the Object Browser; Summary; Chapter 3: The Application Object; Globals; The Active Properties; Display Alerts; Screen Updating; Evaluate; InputBox; StatusBar; SendKeys; OnTime; OnKey; Worksheet Functions; Caller; Summary; Chapter 4: Object-Oriented Theory and VBA; Comparing Classes and Interfaces Defining an InterfaceImplementing an Interface; Defining Methods; Parameters; Implementing Recursive Methods; Eliminating Recursion with Loops; Defining Fields; Defining Properties; Defining Events; Defining Events in Classes; Raising Events; Handling Events; Information Hiding and Access Modifiers; Encapsulation, Aggregation, and References; Summary; Chapter 5: Event Procedures; Worksheet Events; Enable Events; Worksheet Calculate; Chart Events; Before Double Click; Workbook Events; Save Changes; Headers and Footers; Summary; Chapter 6: Class Modules; Creating Your Own Objects Using CollectionsClass Module Collection; Trapping Application Events; Embedded Chart Events; A Collection of UserForm Controls; Referencing Classes Across Projects; Summary; Chapter 7: Writing Bulletproof Code; Using Debug.Print; Using Debug.Assert; A Brief Exemplar of PC Debugging; Creating Reusable Tools with the Debug Object; Tracing Code Execution; Trapping Code Execution Paths; Asserting Application Invariants; Raising Errors; Writing Error Handlers; On Error Goto Line Number; On Error Resume Next; On Error GoTo 0; Using the Err Object; Scaffolding; Writing to the EventLog; Summary Chapter 8: Debugging and TestingStepping Through Code; Running Your Code; Stepping into Your Code; Step Over; Step Out; Run to Cursor; Set Next Statement; Show Next Statement; Using Breakpoints; Using Watches; Add Watch; Edit Watch; Quick Watch; Locals Windows; Testing an Expression in the Immediate Window; Resources for Finding Definitions; Edit => Quick Info; Edit => Parameter Info; Edit => Complete Word; Edit => List Properties/Methods; Edit => List Constants; Edit => Bookmarks; View => Definition; View => Object Browser; Viewing the Call Stack; Asserting Application Invariants; Summary Chapter 9: UserForms |
Altri titoli varianti | Excel 2003 Visual Basic for Applications programmer's reference |
Record Nr. | UNINA-9910806138303321 |
Indianapolis, IN., : Wiley Pub., c2004 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel 2007 for scientists [[electronic resource] /] / by Gerard M. Verschuuren |
Autore | Verschuuren G. M. N (Geert M. N.) |
Edizione | [Rev. & expanded 2nd ed.] |
Pubbl/distr/stampa | Uniontown, OH, : Holy Macro! Books, 2008 |
Descrizione fisica | 1 online resource (275 p.) |
Disciplina |
005.360245
005.54 |
Collana | Excel for Professionals series |
Soggetto topico |
Electronic spreadsheets
Engineering - Data processing Science - Data processing |
Soggetto genere / forma | Electronic books. |
ISBN | 1-932802-66-5 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Front Cover; Contents; About the Author; Introduction; Chapter 1; Chapter 2; Chapter 3; Chapter 4; Chapter 5; Excercises - Part 1; Chapter 6; Chapter 7; Chapter 8; Chapter 9; Chapter 10; Chapter 11; Chapter 12; Chapter 13; Chapter 14; Chapter 15; Chapter 16; Chapter 17; Chapter 18; Chapter 19; Chapter 20; Excercises - Part 2; Chapter 21; Chapter 22; Chapter 23; Chapter 24; Chapter 25; Chapter 26; Chapter 27; Chapter 28; Chapter 29; Chapter 30; Chapter 31; Chapter 32; Excercises - Part 3; Chapter 33; Chapter 34; Chapter 35; Chapter 36; Chapter 37; Chapter 38; Chapter 39; Chapter 40; Chapter 41
Chapter 42Chapter 43; Chapter 44; Excercises - Part 4; Chapter 45; Chapter 46; Chapter 47; Chapter 48; Chapter 49; Chapter 50; Chapter 51; Chapter 52; Chapter 53; Chapter 54; Chapter 55; Chapter 56; Chapter 57; Excercises - Part 5; Index; Back Cover |
Record Nr. | UNINA-9910453929803321 |
Verschuuren G. M. N (Geert M. N.)
![]() |
||
Uniontown, OH, : Holy Macro! Books, 2008 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel 2007 for scientists [[electronic resource] /] / by Gerard M. Verschuuren |
Autore | Verschuuren G. M. N (Geert M. N.) |
Edizione | [Rev. & expanded 2nd ed.] |
Pubbl/distr/stampa | Uniontown, OH, : Holy Macro! Books, 2008 |
Descrizione fisica | 1 online resource (275 p.) |
Disciplina |
005.360245
005.54 |
Collana | Excel for Professionals series |
Soggetto topico |
Electronic spreadsheets
Engineering - Data processing Science - Data processing |
ISBN | 1-932802-66-5 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Front Cover; Contents; About the Author; Introduction; Chapter 1; Chapter 2; Chapter 3; Chapter 4; Chapter 5; Excercises - Part 1; Chapter 6; Chapter 7; Chapter 8; Chapter 9; Chapter 10; Chapter 11; Chapter 12; Chapter 13; Chapter 14; Chapter 15; Chapter 16; Chapter 17; Chapter 18; Chapter 19; Chapter 20; Excercises - Part 2; Chapter 21; Chapter 22; Chapter 23; Chapter 24; Chapter 25; Chapter 26; Chapter 27; Chapter 28; Chapter 29; Chapter 30; Chapter 31; Chapter 32; Excercises - Part 3; Chapter 33; Chapter 34; Chapter 35; Chapter 36; Chapter 37; Chapter 38; Chapter 39; Chapter 40; Chapter 41
Chapter 42Chapter 43; Chapter 44; Excercises - Part 4; Chapter 45; Chapter 46; Chapter 47; Chapter 48; Chapter 49; Chapter 50; Chapter 51; Chapter 52; Chapter 53; Chapter 54; Chapter 55; Chapter 56; Chapter 57; Excercises - Part 5; Index; Back Cover |
Record Nr. | UNINA-9910782140203321 |
Verschuuren G. M. N (Geert M. N.)
![]() |
||
Uniontown, OH, : Holy Macro! Books, 2008 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel 2007 for scientists [[electronic resource] /] / by Gerard M. Verschuuren |
Autore | Verschuuren G. M. N (Geert M. N.) |
Edizione | [Rev. & expanded 2nd ed.] |
Pubbl/distr/stampa | Uniontown, OH, : Holy Macro! Books, 2008 |
Descrizione fisica | 1 online resource (275 p.) |
Disciplina |
005.360245
005.54 |
Collana | Excel for Professionals series |
Soggetto topico |
Electronic spreadsheets
Engineering - Data processing Science - Data processing |
ISBN | 1-932802-66-5 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Front Cover; Contents; About the Author; Introduction; Chapter 1; Chapter 2; Chapter 3; Chapter 4; Chapter 5; Excercises - Part 1; Chapter 6; Chapter 7; Chapter 8; Chapter 9; Chapter 10; Chapter 11; Chapter 12; Chapter 13; Chapter 14; Chapter 15; Chapter 16; Chapter 17; Chapter 18; Chapter 19; Chapter 20; Excercises - Part 2; Chapter 21; Chapter 22; Chapter 23; Chapter 24; Chapter 25; Chapter 26; Chapter 27; Chapter 28; Chapter 29; Chapter 30; Chapter 31; Chapter 32; Excercises - Part 3; Chapter 33; Chapter 34; Chapter 35; Chapter 36; Chapter 37; Chapter 38; Chapter 39; Chapter 40; Chapter 41
Chapter 42Chapter 43; Chapter 44; Excercises - Part 4; Chapter 45; Chapter 46; Chapter 47; Chapter 48; Chapter 49; Chapter 50; Chapter 51; Chapter 52; Chapter 53; Chapter 54; Chapter 55; Chapter 56; Chapter 57; Excercises - Part 5; Index; Back Cover |
Record Nr. | UNINA-9910815108903321 |
Verschuuren G. M. N (Geert M. N.)
![]() |
||
Uniontown, OH, : Holy Macro! Books, 2008 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel 2010 bible [[electronic resource] /] / John Walkenbach |
Autore | Walkenbach John |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, Ind., : Wiley Pub., Inc., 2010 |
Descrizione fisica | 1 online resource (1057 p.) |
Disciplina | 005.54 |
Collana | Bible |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
Soggetto genere / forma | Electronic books. |
ISBN |
1-118-25760-X
0-470-63476-6 1-62198-426-5 1-282-68500-7 9786612685002 0-470-63474-X |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | pt. 1. Getting started with Excel -- pt. 2. Working with formulas and functions -- pt. 3. Creating charts and graphics -- pt. 4. Using advanced Excel features -- pt. 5. Analyzing data with Excel -- pt. 6. Programming Excel with VBA -- pt. 7. Appendixes. |
Record Nr. | UNINA-9910459516903321 |
Walkenbach John
![]() |
||
Indianapolis, Ind., : Wiley Pub., Inc., 2010 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel 2010 bible [[electronic resource] /] / John Walkenbach |
Autore | Walkenbach John |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, Ind., : Wiley Pub., Inc., 2010 |
Descrizione fisica | 1 online resource (1057 p.) |
Disciplina | 005.54 |
Collana | Bible |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
ISBN |
1-118-25760-X
0-470-63476-6 1-62198-426-5 1-282-68500-7 9786612685002 0-470-63474-X |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | pt. 1. Getting started with Excel -- pt. 2. Working with formulas and functions -- pt. 3. Creating charts and graphics -- pt. 4. Using advanced Excel features -- pt. 5. Analyzing data with Excel -- pt. 6. Programming Excel with VBA -- pt. 7. Appendixes. |
Record Nr. | UNINA-9910792418303321 |
Walkenbach John
![]() |
||
Indianapolis, Ind., : Wiley Pub., Inc., 2010 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel 2010 bible [[electronic resource] /] / John Walkenbach |
Autore | Walkenbach John |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, Ind., : Wiley Pub., Inc., 2010 |
Descrizione fisica | 1 online resource (1057 p.) |
Disciplina | 005.54 |
Collana | Bible |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
ISBN |
1-118-25760-X
0-470-63476-6 1-62198-426-5 1-282-68500-7 9786612685002 0-470-63474-X |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | pt. 1. Getting started with Excel -- pt. 2. Working with formulas and functions -- pt. 3. Creating charts and graphics -- pt. 4. Using advanced Excel features -- pt. 5. Analyzing data with Excel -- pt. 6. Programming Excel with VBA -- pt. 7. Appendixes. |
Record Nr. | UNINA-9910814422403321 |
Walkenbach John
![]() |
||
Indianapolis, Ind., : Wiley Pub., Inc., 2010 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel 2010 business basics & beyond [[electronic resource] /] / Chris "Smitty" Smith |
Autore | Smith Christopher |
Pubbl/distr/stampa | Uniontown, Ohio, : Holy Macro! Books, 2012 |
Descrizione fisica | 1 online resource (279 p.) |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
ISBN |
1-61547-210-X
1-61547-330-0 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910790510503321 |
Smith Christopher
![]() |
||
Uniontown, Ohio, : Holy Macro! Books, 2012 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|