Excel VBA Macro Programming by Shepherd, Richard;

Rövid leírás:

Shows how to build VBA macros to maximize the power of Excel. Follow more than twenty sample codes through projects that are practical and useful, and learn to apply VBA programming in unique and useful ways.

Több

Hosszú leírás:

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

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

Több

Tartalomjegyzék:

Part I: Programming in Excel VBA

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

Part II: Object Models

12: The Excel Object Model

13: The Excel Object Model-Main Objects

14: Using Excel to Interact with Other Office Programs

Part III: Advanced Techniques in Excel VBA

15: Charts and Graphs

16: Working with Databases

17: API Calls

18: Class Modules

19: Animation

Part IV: VBA in Action

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

A: ASCII Character Codes

Több