How to give function by cell color to sum two value in Excel
You will not get it to update automatically on change of a cell colour,
because that action does not trigger a worksheet recalculation, so the UDF
cannot automatically be fired. You could add
Application.Volatile
at the start of the function, and then use Alt-F9 to force a recalc when you
change a colour.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"viraj" wrote in message
...
THANK YOU IT WORKS
I copied the code and pasted in VBA module and the the function works. But
the value is not updateing automaticlly as excel does. every time i have
to
double click the function to update the value. How to make the value
change
when i change the color. Please Ref. below
A
1 100 (Red)
2 200
3 300 (Red)
Sum (400)
A
1 100 (Red)
2 200 (Red)
3 300
Sum (400) - this is not updateing automatically i have to double click
then
this value is changing
Regards
|