Publisher's Synopsis
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
- "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
- 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
