Excel 2000 Programming for Dummies (For Dummies Series) - Softcover

Walkenbach, John; Wyatt Sr., Allen L.

Softcover

ISBN 10: 0764505661 ISBN 13: 9780764505669

Publisher: John Wiley & Sons, 1999

Synopsis

If you′re ready to take the next step with Excel, then look no further. By using VBA (Visual Basic Application), you can discover a side of Microsoft Excel that most users never uncover. Excel 2000 Programming For Dummies introduces you to a wide array of new Excel options, including options for creating new worksheet functions; automating tasks and operations; creating new appearances, toolbars, and menus; and doing much more.

First, you get well–acquainted with the most important tools and operations for the Visual Basic Editor; then, you get a quick overview of the essential elements and concepts for programming with Excel. Discover techniques for handling errors and exterminating bugs, the basics of working with range objects and controlling program flow, and much more. With friendly advice on the easiest ways to develop custom dialog boxes (also known as UserForms) and create custom toolbars and menus, you′ll soon be creating the interfaces that best suit your unique needs.

By the time you rip through Excel 2000 Programming For Dummies, you′ll not only have maximized your macros, you′ll have moved on to creating Excel applications with the best programmers on the block.

About this title

About the Author

John Walkenbach is one of the country′s leading authorities on spreadsheet software. He′s principal of Jwalk and Associates Inc., a Southern California–based consulting firm that specializes in spreadsheet application development. John is also a shareware developer, and his most popular product is the Power Utility Pak add–in for Excel. John has written more than 250 articles and reviews for publications such as PC World, InfoWorld, Windows, and PC/Computing. In addition, he′s authored more than 20 other spreadsheet books, including Excel 97 Bible, Excel 97 For Windows For Dummies Quick Reference, and Excel 97 Programming For Windows For Dummies. jwalk.com). When he′s not banging away on his computer keyboard, he′s probably banging away on one of his guitars, trying to cop a few blues licks from Freddie King.

First, you get well-acquainted with the most important tools and operations for the Visual Basic Editor; then, you get a quick overview of the essential elements and concepts for programming with Excel. Discover techniques for handling errors and exterminating bugs, the basics of working with range objects and controlling program flow and much more. With friendly advice on the easiest ways to develop custom dialog boxes (also known as UserForms) and create custom toolbars and menus, you'll soon be creating the interfaces that best suit your unique needs.

By the time you rip through Excel 2000 Programming For Dummies, you'll not only have maximised your macros, you'll have moved on to creating Excel applications with the best programmers on the block.

Edition details

• Publisher: John Wiley & Sons
• Publication date: 1999
• Language: English
• ISBN 10: 0764505661
• ISBN 13: 9780764505669
• Binding: Paperback
• Number of pages: 408