• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part VII: Programming Excel > Taking Control of Excel with VBA

Chapter 30. Taking Control of Excel with VBA

by Bill Ray

  • Understanding object models

    You'll learn how the object model gives VBA access to the full power and functionality of Excel 97.

  • Key objects for Excel VBA

    You'll get a detailed look at some of the most important objects in Excel, which let you control workbooks, worksheets, and ranges.

  • Interacting with the user

    You'll learn how to use VBA's functions for gathering data from your users and presenting messages to them.

  • Creating user-defined functions

    You'll use VBA to create your own functions, which can be used just like Excel's built-in worksheet functions.

  • Programming with events

    You'll run your own macros when certain events occur in Excel, such as opening a workbook or activating a specific sheet.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint