In Excel and others in the Suite, how long do you thing visual basic will last? Do you think Microsoft team will replace/complement VB and Python (or R) will take over VB as the coding language for macro writing?
VBA is an essential part of the Office suite!
So it can't be replaced easily.
VBA will stay for a very long time because of the enormous macros and projects written in it.It lives in millions of workbooks, so I don't think Microsoft will dare break them all.
Excel team might add Python along with VBA as an additional option.