• Contact

  • Newsletter

  • About us

  • Delivery options

  • Prospero Book Market Podcast

  • Excel VBA Macro Programming

    Excel VBA Macro Programming by Shepherd, Richard;

    Series: PROGRAMMING & WEB DEV - OMG;

      • GET 10% OFF

      • The discount is only available for 'Alert of Favourite Topics' newsletter recipients.
      • Publisher's listprice GBP 26.99
      • The price is estimated because at the time of ordering we do not know what conversion rates will apply to HUF / product currency when the book arrives. In case HUF is weaker, the price increases slightly, in case HUF is stronger, the price goes lower slightly.

        12 894 Ft (12 280 Ft + 5% VAT)
      • Discount 10% (cc. 1 289 Ft off)
      • Discounted price 11 605 Ft (11 052 Ft + 5% VAT)

    12 894 Ft

    Availability

    cancelled

    Why don't you give exact delivery time?

    Delivery time is estimated on our previous experiences. We give estimations only, because we order from outside Hungary, and the delivery time mainly depends on how quickly the publisher supplies the book. Faster or slower deliveries both happen, but we do our best to supply as quickly as possible.

    Product details:

    • Publisher McGraw Hill
    • Date of Publication 16 January 2004

    • ISBN 9780072231441
    • Binding Paperback
    • No. of pages320 pages
    • Size 231x185x17 mm
    • Weight 551 g
    • Language English
    • 0

    Categories

    Short description:

    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.

    More

    Long description:

    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



    More

    Table of Contents:

    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

    More

    0