BackCover


Back Cover

Maximize the features and functionality of Excel with help from this unique resource designed specifically for power users. Inside, you ‚ ll find complete details on Excel VBA programming and application development ‚ from the fundamentals to advanced techniques. Then, you ‚ ll 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

About the Author

Richard Shepherd has been developing software for blue-chip corporations for 20 years . He has produced VBA code in Excel for major projects, including profit-and-loss reporting and business planning and budgeting.




Excel VBA Macro Programming
Excel VBA Macro Programming
ISBN: 0072231440
EAN: 2147483647
Year: 2004
Pages: 141

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net