Excel VBA Macro Programming (häftad)
Fler böcker inom
Häftad (Paperback)
Antal sidor
illustrated ed
McGraw Hill
240 x 190 x 30 mm
560 g
Antal komponenter
Excel VBA Macro Programming (häftad)

Excel VBA Macro Programming

Häftad,  Engelska, 2004-01-01
  • Skickas från oss inom 3-6 vardagar.
  • Fri frakt över 249 kr för privatkunder i Sverige.
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, youll find complete details on Excel VBA programming and application development--from the fundamentals to advanced techniques. Then, youll 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
Visa hela texten

Passar bra ihop

  1. Excel VBA Macro Programming
  2. +
  3. Python Crash Course, 3rd Edition

De som köpt den här boken har ofta också köpt Python Crash Course, 3rd Edition av Eric Matthes (häftad).

Köp båda 2 för 876 kr


Har du läst boken? Sätt ditt betyg »

Fler böcker av Richard Shepherd

Övrig information

McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide


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