3rd, in my mind, A "Macro" resides in a tiny little cell, does it's job
with minimal to no further thought on my behalf. "VBA Code" is a bit more
complex and requires a secondary program to write and requires manual
(push a button) effort to execute on a given day.

That is what is normally called a FORMULA. It isn't a macro.