View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Luca[_5_] Luca[_5_] is offline
external usenet poster
 
Posts: 3
Default Linking a range in a class to a cell, with change notification

Hi,

I would like to do a thing, but I do not know if it is possible: I
have a class, where I defined an object: a range of a single cell.

I would like to know if there is a way to raise a "change" event
whenever the referred cell value changes.

I know that this can be done using a sheet module and a
Worksheet_Change event, but I need to have tat event directly in
classes, since I cannot use sheets modules.

If this cannot be done do you have any idea about how I can detect a
cell change from a class?

Bye & tks

Luca