Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
Maximize the features and functionality of Excel with help from this unique resource designed specifically for power users. Inside, youll find complete details on Excel VBA programming and application development--from the fundamentals to advanced techniques. Then, youll get 21 real-world projects, complete with working code, so you can create Excel VBA macros right away. These projects include everything from setting up timed events to auto totaling a matrix of numbers to altering the appearance of spreadsheet components--and much more.
- Write and debug VBA code
- Create custom dialog boxes and toolbars
- Take advantage of the Excel object model
- Write code to interact with a database
- Use application programming interface (API) calls
- Create and use class modules
- Develop unique menus within the Excel menu structure
- Expand calculation and search functions
- Write macros for customized worksheets
- Create full-fledged Excel add-ins
Part I: Programming in Excel VBA1: The Basics2: Variables, Arrays, Constants, and Data Types3: Modules, Functions, and Subroutines4: Programming Basics: Decisions and Looping5: Strings and Functions and Message Boxes6: Operators7: Debugging8: Errors and the Error Function9: Dialogs10: Common Dialog Control11: Command Bars and ButtonsPart II: Object Models12: The Excel Object Model13: The Excel Object Model-Main Objects14: Using Excel to Interact with Other Office ProgramsPart III: Advanced Techniques in Excel VBA15: Charts and Graphs16:l6
![Excel VBA Macro Programming [Paperback]](/itemImage/2/3/4/6/2_1437953.jpg)