Excel VBA Programming for Dummies

John Walkenbach - Collection For Dummies

408 pages, parution le 07/09/2004

Ajouter à une liste

Indisponible

Résumé

Shows ordinary users how to harness the power of Visual Basic for Applications (VBA) and create custom Excel applications
This book introduces people to a wide array of new Excel options, including creating new worksheet functions, automating tasks and operations, creating new toolbars and menus, designing custom dialog boxes and add-ins, and much more
Begins with the most important tools and operations for the Visual Basic Editor, then provides an overview of the essential elements and concepts for programming with Excel
John Walkenbach, a.k.a. "Mr. Spreadsheet," runs a popular Web site (www.j-walk.com) on Excel techniques and is the author of many bestselling books on Excel

L'auteur - John Walkenbach

Surnommé Mr. Spreadsheet (Monsieur Tableur), John Walkenbach est un spécialiste reconnu des tableurs, et plus particulièrement d'Excel, Auteur de plus de 30 ouvrages et de 300 articles, il a été récompensé pour son utilitaire Power Utility Pak.

Autres livres de John Walkenbach

Programmation VBA pour Excel 2022 pour les nuls

Excel 2019 et VBA pour les nuls

Programmation VBA pour Excel 2019 pour les nuls

Programmation VBA pour Excel pour les nuls

Découvrir tous les livres de John Walkenbach

Sommaire

Part I: Introducing VBA.
- What Is VBA?
- Jumping Right In.
Part II: How VBA Works with Excel.
- Introducing the Visual Basic Editor.
- Introducing the Excel Object Model.
- VBA Sub and Function Procedures.
- Using the Excel Macro Recorder.
Part III: Programming Concepts.
- Essential VBA Language Elements.
- Working with Range Objects.
- Using VBA and Worksheet Functions.
- Controlling Program Flow and Making Decisions.
- Automatic Procedures and Events.
- Error-Handling Techniques.
- Bug Extermination Techniques.
- VBA Programming Examples.
Part IV: Developing Custom Dialog Boxes.
- Custom Dialog Box Alternatives.
- Custom Dialog Box Basics.
- Using Dialog Box Controls.
- UserForm Techniques and Tricks.
Part V: Creating Custom Toolbars and Menus.
- Customizing the Excel Toolbars.
- When the Normal Excel Menus Aren't Good Enough.
Part VI: Putting It All Together.
- Creating Worksheet Functions - and Living to Tell about It.
- Creating Excel Add-Ins.
- Interacting with Other Office Applications.
Part VII: The Part of Tens.
- Ten VBA Questions (And Answers).
- (Almost) Ten Excel Resources

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wiley
Auteur(s)	John Walkenbach
Collection	For Dummies
Parution	07/09/2004
Nb. de pages	408
Format	19 x 23
Couverture	Broché
Poids	540g
Intérieur	Noir et Blanc
EAN13	9780764574122
ISBN13	978-0-7645-7412-2