I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

sbSumMyFormat

If you have an area filled with numbers of different currencies (i.e. different number formats) and if you need to calculate totals for all of these:

sbSumMyFormat_01_Screen
sbSumMyFormat_01_Code

Please note that changing a cell color does not trigger a recalculation of dependent cells.

You would need to invoke manually with CTRL + ALT + F9, for example.

Other reasonable options to ensure an up-to-date calculation of dependent cells are a manual button which starts the recalc or an event procedure which starts this whenever a different cell is being selected, for example.

If you are interested in downloading a 29 KB sample file which contains the functions discussed here, go to my Download page, please.

Another example on how to count colored cells: [Cells B1:B10 are named ColoredRange here]

sbCountMyColor_01_Screen
sbCountMyColor_01_Code
sbCountMyColor_02_Code
Sulprobil   Get it done   Contact   Disclaimer   Download