PDA

View Full Version : Solved: colorIndex change event



bodhi
04-30-2008, 03:16 PM
Hi,

Is there a way that i can get a sub routine to run based on a change to the colorIndex within a range.

I have tried using "Worksheet_Change" and the code works OK when I change data within the range but it does not respond to changes to the cell colour.



:help

Bodhi.

Bob Phillips
04-30-2008, 03:54 PM
No, a colour change, or any format change for that matter, does not trigger an event. Shame, but that is how it is.

bodhi
04-30-2008, 04:09 PM
Thanks xld.

looks like i'll have to try another tact.

i really wanted it to update automatically on the change of color but i may just have to add a command button to the sheet.

hmmmmmmm....