Auto Recalculate instead of pressing F9
Hi All,
I've the below codes and every time i need to press F9 to recalculate it.. is there any code to add in the module to recalculate automatically when value changes.
I tried some of the codes and it doesn't work..
Please Login or Register to view this content.
With Application.Volatile your UDF will recalculate every time when sheet recalculates (even if it is not necessary, i.e. no change in the input arguments). http://www.cpearson.com/excel/writin...ionsinvba.aspx
The problem is that you want the UDF to recalculate, when there is change in font color, which however does not trigger recalculations at all (value does not change).
One work-around that comes to my mind is to use Worksheet_Change event to fire sheet recalculation (which will in turn recalculate the UDF).
If you are pleased with a member's answer then use the Star icon to rate it.
I do not recommend this though, safer Selection_Change rather than Change event IMO.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks