• 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

    Hui...

  • 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

Status
Not open for further replies.

Saitej1234

New Member
>>> use code - tags <<<
Code:
Function Sumcolor(cellcolor as Range, rRange as Range)
Application.volatile
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:
Status
Not open for further replies.
Back
Top