IUpdatedValues

Defines the public contract for the UpdatedValues class, exposing methods to register, query, and maintain a column-level update watcher backed by a registry of ListObjects on a dedicated worksheet.

Column registration

AddColumns #

Register or refresh watched columns for the supplied ListObject.

Signature:

Public Sub AddColumns(ByVal Lo As ListObject): End Sub

Scans the source ListObject header row for metadata tags and synchronises the registry table so named ranges remain aligned with the current layout.

Parameters:

  • Lo: ListObject. Table providing the column metadata.

AddSheet #

Register tagged columns for every ListObject on the supplied worksheet.

Signature:

Public Sub AddSheet(ByVal targetSheet As Worksheet): End Sub

Parameters:

  • targetSheet: Worksheet. Worksheet providing ListObjects to register.

RemoveLo #

Remove registry entries associated with the provided ListObject.

Signature:

Public Sub RemoveLo(ByVal target As ListObject): End Sub

Parameters:

  • target: ListObject. Table whose entries should be removed.
Status tracking

IsUpdated #

Determine whether the tracked column has been marked as updated.

Signature:

Public Property Get IsUpdated(ByVal colName As String) As Boolean: End Property

Returns True when the column has been flagged as updated since the last reset. Searches across all registry ListObjects for a matching entry.

Parameters:

  • colName: String. Column name to inspect.

Returns: Boolean. True when the column is flagged as updated.

CheckUpdate #

Evaluate a range change against the registered watchers and flag updates.

Signature:

Public Sub CheckUpdate(ByVal tagReference As Variant, ByVal Target As Range): End Sub

Compares the changed range with named ranges tracked in the registry and marks the first matching entry as updated. The tagReference parameter may be a String, ListObject, or Worksheet used to scope the search.

Parameters:

  • tagReference: Variant. Identifier selecting the registry scope.
  • Target: Range. The changed cells to evaluate.
Clean-up

ClearUp #

Reset all tracked columns to the default (not updated) status.

Signature:

Public Sub ClearUp(): End Sub

DeleteUp #

Remove the watcher registry and associated workbook named ranges.

Signature:

Public Sub DeleteUp(): End Sub

SwitchTagsToNo #

Force every registry status flag to the default value.

Signature:

Public Sub SwitchTagsToNo(): End Sub

SwitchTagsToYes #

Force every registry status flag to the updated value.

Signature:

Public Sub SwitchTagsToYes(): End Sub