Skip to Main Content
Writing Excel Macros with VBA, 2nd Edition
book

Writing Excel Macros with VBA, 2nd Edition

by Steven Roman PhD
June 2002
Beginner content levelBeginner
570 pages
16h 48m
English
O'Reilly Media, Inc.
Content preview from Writing Excel Macros with VBA, 2nd Edition

Name

Watch Object

Synopsis

Path: Application  --  Watches - Watch
               

Object

Methods

Properties

Watch

  • Delete( )

  • Source( ) As Variant

Watches

  • Add(Source As Variant) As Watch

  • Delete( )

  • Count( ) As Long

  • Item(Index As Variant) As Watch

The Excel XP Watch window toolbar is a very simple, yet useful tool. It enables the user to view the contents of a cell even when the portion of the worksheet that contains the cell is not visible. Figure G-2 shows the Watch Window Toolbar.

The Watch Window
Figure G-2. The Watch Window

The Watch object implements the Watch Window programmatically.

The Watches property of the Application object returns a Watches collection that contains all of the open Watch objects. The Watch object itself has only one really useful property—the Source property, which specifies the cell to watch. The Watch object has only one method—Delete, which deletes the watch.

To illustrate, the watch in Figure G-2 can be created in either of the following ways:

Dim wa As Watch
Set wa = Application.Watches.Add("A1")
Set wa = Application.Watches.Add(Range("A1"))
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft Excel 2019 VBA and Macros, First Edition

Microsoft Excel 2019 VBA and Macros, First Edition

Bill Jelen, Tracy Syrstad
VBA and Macros for Microsoft Excel

VBA and Macros for Microsoft Excel

Bill Jelen, Tracy Syrstad
Excel 2016 VBA and Macros

Excel 2016 VBA and Macros

Bill Jelen, Tracy Syrstad

Publisher Resources

ISBN: 0596003595Supplemental ContentErrata Page