#1
|
|||
|
|||
Can someone help to trigger this VBA function?
In an Excel I use a self made function "sumbycolor" to add cells in the same column with 2 different colours (blue and green). It adds nicely, the cells in green seperately from the cells in blue. But when I change a blue cell into green, the sums of blue and green do not automatically adapt themselves to the changed values. It seems that the color change itself does not trigger the sum function to recalculate. Can I do something about this? |
#2
|
|||
|
|||
Quote:
Is your sumbycolor UDF volitile ? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I trigger a macro from a document? | brucemc777 | Word VBA | 4 | 01-25-2016 01:42 AM |
How to trigger an animation with keyboard shortcuts? | Indy | PowerPoint | 1 | 09-14-2015 09:33 AM |
Autocorrect trigger problem | kcvinu | Word | 1 | 07-03-2015 10:41 PM |
Word VBA: How to create a command button and trigger a function? | tinfanide | Word VBA | 2 | 12-02-2011 05:51 AM |
Desperatly need help in trigger animations | quinn307 | PowerPoint | 0 | 03-27-2011 08:52 PM |