Bibliograph

Excel VBA programming, by Dick Kusleika

Type

Label

Excel VBA programming, by Dick Kusleika

Language

eng

Illustrations

illustrations

Index

index present

Literary Form

non fiction

Main title

Excel VBA programming

Oclc number

1266256470

Responsibility statement

by Dick Kusleika

Series statement

For dummies

Summary

"Find out what Excel is capable of with this step-by-step guide to VBA. Short of changing the tires on your car, Microsoft Excel can do pretty much anything. And the possibilities are even more endless when you learn to program with Excel Visual Basic for Applications (VBA). Regardless of your familiarity with Excel VBA, Excel VBA Programming For Dummies can enhance your experience with the popular spreadsheet software. Pretty soon, you'll be doing things you didn't think were possible in Excel, from automating processes to writing your own worksheet functions. You'll learn how to: Understand the basic tools and operations of Visual Basic for Applications; Create custom spreadsheet functions that make life easier for you and the people maintaining your spreadsheets; Deal with errors and exceptions and eliminate the bugs in your code. Perfect for anyone who's never even heard of Excel VBA, Excel VBA Programming For Dummies is also a fantastic resource for intermediate and advanced Excel users looking for a heads-up on the latest features and newest functionality of this simple yet powerful scripting language"--Publisher's description

Table Of Contents

Starting Excel VBA programming. Getting to know VBA ; Building simple macros -- Employing VBA with Excel. Working in the Visual Basic Editor ; Introducing the Excel object model ; VBA sub and function procedures ; Using the Excel macro recorder -- 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 -- Communicating with your users. Simple dialog boxes ; UserForm basics ; Using UserForm controls ; UserForm techniques and tricks ; Accessing your macros through the user interface -- Putting it all together. Creating worksheet functions ; Creating Excel add-ins -- The part of tens. Ten handy Visual Basic Editor tips ; Resurces for VBA help ; Ten VBA do's and don'ts

Target audience

adult

resource.variantTitle

Excel VBA programming for dummies

Classification