1.

Record Nr.

UNINA9910449940303321

Titolo

Excel 2003 VBA programmer's reference [[electronic resource] /] / Paul Kimmel ... [et al.]

Pubbl/distr/stampa

Indianapolis, IN., : Wiley Pub., c2004

ISBN

1-280-26598-1

9786610265985

0-7645-7898-7

Edizione

[1st edition]

Descrizione fisica

1 online resource (1176 p.)

Collana

Programmer to programmer

Altri autori (Persone)

KimmelPaul

Disciplina

005.54

Soggetti

Business - Computer programs

Electronic spreadsheets

Computer software - Development

Electronic books.

Lingua di pubblicazione

Inglese

Formato

Materiale a stampa

Livello bibliografico

Monografia

Note generali

Includes index.

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

Sommario/riassunto

What is this book about? Excel 2003 VBA Programmer's Reference is an updated and expanded version of the two previous editions now with a reference section downloadable from the Web for easy perusal. The book is aimed at Excel users who want to gain more control over their spreadsheets using VBA or who want to develop Excel applications for other users. The book starts with a primer chapter focused on bringing the readers up to speed with Excel and VBA. From there, the book expands to focus on major issues faced by advanced Excel users and developers. What does this book c



2.

Record Nr.

UNINA9910462349403321

Autore

Denes Gianfranco

Titolo

Talking heads : the neuroscience of language / / Gianfranco Denes

Pubbl/distr/stampa

Hove, East Sussex ; ; New York : , : Psychology Press, , 2011

ISBN

1-136-47584-2

1-280-68362-7

0-203-13141-X

Descrizione fisica

1 online resource (261 p.)

Disciplina

612.8/2336

Soggetti

Neurolinguistics

Language disorders

Psycholinguistics

Electronic books.

Lingua di pubblicazione

Inglese

Formato

Materiale a stampa

Livello bibliografico

Monografia

Note generali

"Authorized translation from Italian language ed. published by Zanichelli."

First published 2009 by Zanichelli, Italy.

Nota di bibliografia

Includes bibliographical references and indexes.

Nota di contenuto

(Publisher-supplied data) CHAPTER 1 DEFINING LANGUAGE -- CHAPTER 2 THE ORIGIN AND EVOLUTION OF LANGUAGE -- CHAPTER 3 THE ANATOMY OF LANGUAGE -- CHAPTER 4 ACQUIRED LANGUAGE DISORDERS: THE APHASIAS -- CHAPTER 5 THE SOUNDS OF LANGUAGE: THE PRODUCTION AND COMPREHENSION OF WORDS --   CHAPTER 6 THE WORDS TO SAY IT: THE FUNCTIONAL AND NEUROLOGICAL ARCHITECTURE OF THE LEXICAL SYSTEM -- CHAPTER 7 THE TRAINS OF LANGUAGE: SYNTAX AND MORPHOLOGY -- CHAPTER 8 THE NEUROLOGICAL BASES AND FUNCTIONAL ARCHITECTURE OF WRITTEN LANGUAGE -- CHAPTER 9 THE NEUROLOGICAL BASES AND FUNTIONAL ARCHITECTURE OF BILINGUALISM --   CHAPTER 10 SPEAKING WITH OUR HANDS: SIGN LANGUAGE -- CHAPTER 11 LANGUAGE ACQUISITION AND DEVELOPMENTAL LANGUAGE DISORDERS.

Sommario/riassunto

"The origin, development, and nature of language has been the focus of theoretical debate among philosophers for many centuries. Following the discovery 150 years ago that language is a biological system, an increasing number of neuroscientists began to search for its anatomical



basis and its links with other such systems. The relatively recent introduction of neuroimaging tools, such as PET and MRI, has brought rapid and groundbreaking developments to the field of Neurolinguistics. In this book, Denes and Smith harness these advances to adopt a biolinguistic approach to the study of a subject that increasingly sees the collaboration of linguists, experimental psychologists, neuroscientists and clinicians. Following an up-to-date description of acquired language disorders, and their contribution to the design of a functional architecture of language, the book illustrates the neurological process involved in the production of written language, as well as investigating the neurological systems responsible for sign language production and second language acquisition. Talking Heads reviews the latest research on the nature, structure and origin of language to provide a concise analysis of the multifaceted aspects of language which focuses both on theoretical aspects and physical implementation. With a glossary of the anatomical and linguistic terms, this book provides an invaluable resource to undergraduate and graduate students of Psychology, Psycholinguistics and Linguistics. It will also be of interest to neurologists, speech therapists and anyone interested in the mind-brain problem"--Provided by publisher.