I am looking for code that continues to total, in the TOTAL cell, when numbers are changed in the totalling cells.
The factors that govern the change are a new entry from a combo box.
It would be nice to be able to clear the summing cells on this change.
ie.
Supposing cells C3,C4,C5, = 2,2,2 =6 in say C10
a new entry is added to cell A4 from a combo box
then cells C3,C4,C5, clear
new entries are added to C3,C4,C5= 3,3,3 (which would =9)
this figure is added to the previous total, in this case 6
new total would =6+9= 15 in C10
and so on until a command button is activated.
Ted
The factors that govern the change are a new entry from a combo box.
It would be nice to be able to clear the summing cells on this change.
ie.
Supposing cells C3,C4,C5, = 2,2,2 =6 in say C10
a new entry is added to cell A4 from a combo box
then cells C3,C4,C5, clear
new entries are added to C3,C4,C5= 3,3,3 (which would =9)
this figure is added to the previous total, in this case 6
new total would =6+9= 15 in C10
and so on until a command button is activated.
Ted