• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to auto update UDF'S in excel

Not open for further replies.


New Member
>>> use code - tags <<<
Function Sumcolor(cellcolor as Range, rRange as Range)
Dim csum as double
Dim colindex as integer
Colindex = cellcolor.interior.colorindex
For each cl in Range
If cl.interior.colorindex = colindex then
Csum = worksheetfunction.sum(cl, csum)
End if
Next cl
Sumcolor = csum
End function
The above function is not updating the calculation automatically when i change the color of cell .but it is updating when i press f9.please help me to autoupdate when ever i change the color without Pressing f9.
Last edited by a moderator:
Not open for further replies.