|
Each step in this visual reference is displayed with callouts so you can see exactly where the action takes place on the screen. It covers over 100 tasks, including complete coverage of macros -- with info about VBA basic techniques, variables and arrays, control statements, interfacing with other macros, debugging, add-ins, and automation.
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 140 key VBA programming techniques for Excel macros, including:
- Working with the Visual Basic Editor
- Using the Excel Object Model
- Utilizing variables and arrays
- Harnessing built-in functions
- Debugging macros
- Defining ranges
- Manipulating cells
- Customizing dialog boxes
- Working with charts
- Automating procedures
Extra Apply It
- "Apply It" and "Extra" sidebars highlight useful tips
- High-resolution screen shots demonstrate each task
- Succinct explanations walk you through step by step
- Two-page lessons break big topics into bite-sized modules
VBA development tools on CD-ROM!
- Code_Crafter 2000 and VBA code Print trial version
- Barcode Add-in for Office demo
- VB Code Cutter shareware
- All sample code and spreadsheets from the book
- Searchable e-version of the book
System requirements: PC running Windows 9x/2000/Me/XP, Windows NT 4 or later. See the "What's on the CD-ROM" Appendix for details and complete system requirements.
About the Author
About the Author Jinjer Simon has been actively involved in the computer industry for the past 17 years. Her involvement in the industry has included 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 Windows CE For Dummies and Windows CE 2 For Dummies. Jinjer and her husband live in Coppell, Texas with their two children. She currently works as a consultant for MillenniSoft, Inc., providing Web site development and online documentation development. |
|
|
 Algorithms in Java: Parts 1-4, Third EditionSedgewick has a real gift for explaining concepts in a way that makes them easy to understand. The use of real programs in page-size (or less) chunks that can be easily understood is a real plus. The figures, programs, and tables are a significant contribution to the learning experience of the reader; they make this book... | | Writing Secure Code, Second EditionIf you design applications, or if you build, test, or document solutions, you need this book. If your applications are Web-based or Win32-based, you need this book. Finally, if you are currently learning or building Microsoft .NET Framework–based applications, you need this book. In short, if you are involved in building... | | Security Planning and Disaster RecoverySecrets and strategies for protecting your network before trouble strikes
Create and implement a successful security system and recovery plan with help from this insightful and practical resource. This detailed guide provides you with a complete roadmap for developing an effective end-to-end security program. You’ll even... |
UNIX: The Complete Reference, Second EditionGet cutting-edge coverage of the newest releases of UNIX--including Solaris 10, all Linux distributions, HP-UX, AIX, and FreeBSD--from this thoroughly revised, one-stop resource for users at all experience levels. Written by UNIX experts with many years of experience starting with Bell Laboratories, UNIX: The Complete Reference, Second... | | Learn Excel 97 Through Excel 2007 from Mr. Excel: 377 Excel Mysteries Solved!Updating the previous edition's tips to make them compatible with Excel 2007, and featuring new tips that are only available in Excel 2007, this new edition of Mr. Excel's popular software guide even incorporates suggestions sent in by readers. Each featured topic has a problem statement and description, followed by a broad... | | |
|
