Sale!

Excel VBA Macro Programming 1st Edition by Richard Shepherd ISBN 0072231440 978-0072231441

Original price was: $50.00.Current price is: $35.00.

Excel VBA Macro Programming 1st Edition Richard Shepherd Digital Instant Download

Author(s): Richard Shepherd
ISBN(s): 9780849322945, 0849322944
Edition: 1
File Details: PDF, 5.84 MB
Year: 2004
Language: english
SKU: EB-1269700 Category: Tag:

Excel VBA Macro Programming 1st Edition by Richard Shepherd- Ebook PDF Instant Download/Delivery: 0072231440, 978-0072231441
Full download Excel VBA Macro Programming 1st Edition  after payment

Product details: 

ISBN 10: 0072231440 

ISBN 13: 978-0072231441

Author: Richard Shepherd

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 (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

Table of contents: 

  1. The Basics

  2. Variables, Arrays, Constants, and Data Types

  3. Modules, Functions, and Subroutines

  4. Programming Basics: Decisions and Looping

  5. Strings and Functions and Message Boxes

  6. Operators

  7. Debugging

  8. Errors and the Error Function

  9. Dialogs

  10. Common Dialog Control

  11. Command Bars and Buttons

  12. The Excel Object Model

  13. The Excel Object Model – Main Objects

  14. Using Excel to Interact with Other Office Programs

  15. Charts and Graphs

  16. Working with Databases

  17. API Calls

  18. Class Modules

  19. Animation

  20. Converting Labels to Numbers and Numbers to Labels

  21. Transposing a Range of Cells

  22. Adding Formula Details into Comments

  23. Calculating a Range

  24. Reversing a Label

  25. Who Created the Workbook?

  26. Evaluating a Cell

  27. Sorting Worksheets into Alphabetical Order

  28. Replacing Characters in a String

  29. Timed Events

  30. Auto Totaling a Matrix of Numbers

  31. Absolute and Relative Formulas

  32. Coloring Alternate Rows and Columns of the Spreadsheet

  33. Coloring Cells Containing Formulas

  34. Summing Cells by Reference to a Master Cell

  35. Globally Changing a Range of Values

  36. Displaying Hidden Sheets Without a Password

  37. Searching Multiple Sheets and Workbooks

  38. Brighten Up Your Comments

  39. An Alternative to Message Boxes

  40. Working with Shapes

  41. Turning Your VBA Code into an Add-In

  42. ASCII Character Codes

People also search for:

    
macro programming excel
    
microsoft excel vba programming for the absolute beginner
    
microsoft excel vba programming
    
excel vba macro progress bar
    
excel vba programming training
    

Tags: Richard Shepherd, Excel VBA, Macro Programming