I probably worded that badly.

I try to avoid the type of system design where a selection change  would be
necessary to achieve the result. It tend to favour either more active
solutions (button clicks or cell change events) or more passive solutions
(values deduced from other cells, rather than cells  filled with specific
values at the time).

On occasions, though, a selection change is certainly the best way to go.