It kind of sounds like you may want to use an application event (narrowed only
to look at a certain workbook/worksheet/range)???

You can read a lot more about application events at Chip Pearson's site:
http://www.cpearson.com/excel/AppEvent.htm

===
Could you use "Workbook_SheetChange" under the ThisWorkbook (narrowed to look at
that certain worksheet/range)???


Luca wrote:

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

--

Dave Peterson