Have a Macro run automatically when a cell in a range is updated or changed

[neholsti]

I wanted a macro I wrote to run automatically if a cell in a range changes instead of using a button. This code I used for the macro is as follows:

Function colornumber(myvar As Range)
colornumber = myvar.Interior.ColorIndex
End Function
Function colorcount(myvar As Range, ColVar As Long)
For Each cell In myvar
If cell.Interior.ColorIndex = ColVar Then colorcount = colorcount + 1
Next
End Function

Any help is greatly appreciated!

 

[Jerry Sullivan]

Hi, You can search this site for examples using a Worksheet_Change event.

Good luck,

 

[neholsti]

I guess my question is more about how to implement it with the code that I have...

 

[Jerry Sullivan]

Here is a good explanation from Chip Pearson.
http://www.cpearson.com/excel/Events.aspx
If you need help implementing it with your code, please post your best attempt and the problem you encounter. I'll be glad to help you fix it.