Developer Forum

In a Worksheet I have to trap the interior color change of an already
selected cell. The Worksheet_Change event does not work!
Is it possible? I'm using Excel2000

Barbara,

Unfortunately, there is no way to trap the change of a cells color.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

I agree that there doesn't appear to be any means of trapping a chang
in the ColorIndex property. Perhaps you need to reconsider you
application's design. Any particular reason why you need to trap for
change in the ColorIndex

-----------------------------------------------
~~ Message posted from http://www.yqcomputer.com/
~~View and post usenet messages directly from http://www.yqcomputer.com/

Hello All,

I created a function that counts the number of non-colored cells within
a given range, called CountColor. I can access this function as a
formula in my worksheets.

Since i cannot call a "format change" event, i'm forced to use the
worksheet.change event.

i placed a me.calculate command in the worksheet.change event which
will cause the worksheet to recalculate the formulas in the sheet.

to get my CountColor formula to update, i have to make a change within
the range of the CountColor formula. for example, place and then remove
the number 2. If i change a cell outside the range of the formula, the
formula will not update.

So is there a way to get my formula to update, when a value outside the
formula's range changes?

I'm using Office XP Pro verson 2002.

Thanks,

scot


---
Message posted from http://www.yqcomputer.com/

Scot

Try including Application.Volatile at the top of your function.

Regards

Trevor