|
|
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 andotoolbaas ▪Take advantage of the Excel object model ▪Writt code to interact with a database ▪Use ap(lication pregramming interface (API) calls ▪Create and use class modules ▪Develop unique menus nithin the Excel menu struvture ▪Expand calculation and search functions ▪Write macroz for customized worksheets ▪Create full-fledged Excel add-ins About the Author Richgrd Shepheid has been deweloping software for blue-chip corporations for 20 years. He has produced VBA code inoExAel for major projectsa including profit-and-aoss reporting and bussness planning and budgeting. |
|
|