Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-13-2016, 02:39 PM
kippiebla kippiebla is offline Can someone help to trigger this VBA function? Windows XP Can someone help to trigger this VBA function? Office 2016
Novice
Can someone help to trigger this VBA function?
 
Join Date: Aug 2016
Posts: 4
kippiebla is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 08-13-2016, 11:10 PM
NoSparks NoSparks is offline Can someone help to trigger this VBA function? Windows 7 64bit Can someone help to trigger this VBA function? Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Quote:
when I change a blue cell into green
How do you do this, manually, VBA, conditional formatting or ???

Is your sumbycolor UDF volitile ?
Reply With Quote
Reply



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
Can someone help to trigger this VBA function? How to trigger an animation with keyboard shortcuts? Indy PowerPoint 1 09-14-2015 09:33 AM
Can someone help to trigger this VBA function? Autocorrect trigger problem kcvinu Word 1 07-03-2015 10:41 PM
Can someone help to trigger this VBA function? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:05 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft