zCellWatch
A Watch window like the VBE Watch window, for worksheets
zCellWatch was developed after a user saw me using the Watch window in the VBE and said they'd like a version for their spreadsheet.
I wasn't sure it'd catch on, but then imagine my surprise to see a version in Personal Computer World's review of Office 10 beta!
Well, here's my version, almost identical to the one I could see in their text. The form looks like this:
The form uses a ListView, part of a group of ActiveX controls that are found in the MSCOMCTL.OCX file. If you're using Excel 2000 or later, you should have a copy.
24 Jan 2001 - Updated to allow form resizing - said code supplied by Stephen Bullen - BMS Ltd
27 Jan 2001 - Refresh bug corrected
10 May 2001 - Several updates, Remove Watch updated to fix bug and allow multiple selection/deletion
A Watch window like the VBE Watch window, for worksheets
zCellWatch was developed after a user saw me using the Watch window in the VBE and said they'd like a version for their spreadsheet.
I wasn't sure it'd catch on, but then imagine my surprise to see a version in Personal Computer World's review of Office 10 beta!
Well, here's my version, almost identical to the one I could see in their text. The form looks like this:
The form uses a ListView, part of a group of ActiveX controls that are found in the MSCOMCTL.OCX file. If you're using Excel 2000 or later, you should have a copy.
24 Jan 2001 - Updated to allow form resizing - said code supplied by Stephen Bullen - BMS Ltd
27 Jan 2001 - Refresh bug corrected
10 May 2001 - Several updates, Remove Watch updated to fix bug and allow multiple selection/deletion
