Hello all,
Today I was working on a small assignment and I decided to share it with this community as
1) it might be of value to others and
2) I am curious if it could be done in another/shorter way.
The assignment was: make a table where users can enter values which are automatically
summed, but users must also be able to fill in a value as total instead of entering (any)
separate values. In case a total had been given, but (any) separate values are
entered later on, they must be summed after all (so then the sum function must be restored).
autoSumMultipleCells.PNG
This is the code in the sheet module:
That's quite a bit of code for a relatively simple task - I wonder - could this be done in a shorter, simpeler way?
(I would have attached the sample file if the Attachments button would've worked - in case you want it, send me a PM with your e-mail address.)
Grtz, BartH
Bookmarks