Excel Programming

Your visual blueprint for creating interactive spreadsheets

Jinger Simon - Collection Read Less - Learn More

350 pages, parution le 03/10/2005 (2^eme édition)

Ajouter à une liste

Indisponible

Résumé

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 120 key Excel programming techniques, including:

Creating and launching keyboard shortcuts
Setting macro security
Assigning a digital signature
Developing a function with VBA
Displaying a built-in dialog box
Converting a list into an array
Using the msgbox function
Processing a runtime error
Saving a workbook in a specified format
Finding the intersection of two ranges

L'auteur - Jinger Simon

Jinjer Simon has been actively involved in the computer industry for the past 18 years. Her involvement includes programming, providing software technical support, training end-users, developing written and online user documentation, creating software tutorials, and developing Web sites. She is the author of several computer books, including Excel Programming: Your visual blueprint for creating interactive spreadsheets, and Windows CE 2 For Dummies.

Sommaire

Getting stared with excel macros
Using the visual basic editor
VBA programming basics
Working with the excel object model
Using variables and arrays
Adding control statements
Using built-in functions and statements
Debugging macros
Working with other workbooks and files
Working with worksheets
Defining ranges
Working with cells
Customizing dialog boxes, menus, and toolbars
Working with charts
Automating procedures with excel events
Appendix a: VBA quick reference
Appendix b: about the cd-rom

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wiley
Auteur(s)	Jinger Simon
Collection	Read Less - Learn More
Parution	03/10/2005
Édition	2^eme édition
Nb. de pages	350
Format	20,5 x 23
Couverture	Broché
Poids	780g
Intérieur	Noir et Blanc
EAN13	9780764597817
ISBN13	978-0-7645-9781-7