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.
Develop powerful, custom Excel applications using Visual Basic for Applications
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 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
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.
Develop powerful, custom Excel applications using Visual Basic for Applications
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 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