How to trap the change of color event in a cell?

  • Thread starter Thread starter Barbara
  • Start date Start date
B

Barbara

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
 
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
 
Scot

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

Regards

Trevor
 
Back
Top