When I started working on Visual Basics, especially in Excel, I was also worried about the same, because my company heavily depended upon VBA and dashboards built on VBA scripts.

Having said that, it was around 5 years back, and VBA is still in demand these days.

Long story short, VBA is here to stay with us until our lifetime at least.

This is because there are so many organizations that have built business-critical dashboards and macros using VBA which Microsoft will never want to disrupt. They are not going to announce overnight that from tomorrow the products are unavailable. 

Also, some teams use Excel VBA and some of the legacy systems are also built on Visual Basics. This happens because Tech Teams in any organization are busy working for clients therefore, someone who is good at Excel or VBA codes their dashboards and reporting systems.

Another reason is the simple and clear English language that is used in VBA. Most of the work that you do can be achieved in VBAs, because of which it also becomes newbie friendly. Therefore, VBA in desktops and laptops is going to be there. You don't need to look for jobs in other fields this soon, but it is always good to acquire new skills as you grow.

But this might not be true for online versions of Excel
Now, as we know excel is expanding into online versions as well, which also supports collaboration with teams just like google sheets. For this, Microsoft is also clear that they don't want to take VBA further to online versions for example, in collaborative Excel sheets, excel for ios, or Excel for Android systems.

For this, Microsoft is working on the Excel-js kind of thing, where the language used will be based on Java Scripts. 

This will surely revolutionize the way we use Excel and its developmental capabilities, but still, that will have some limitations. As Excel is something that everyone uses in their home, one can learn by experimenting with Macros, downloading files, and breaking their codes to rewrite them, but it seems Microsoft will make the self-learning process a bit difficult as not everyone will be having an office one drive connection where they will be able to use online excel sheets.

This is again a long-distant vision, it might take some time for Microsoft to implement the same as well.

Other options might be using Python, but because it is again an open-source language, there will be requirements for safety and security measures for the code to run properly.

So in a nutshell, one can say that Excel and VBA both are going to be there at least on the desktop versions, and you need not worry about finding new jobs or learning new skills too fast. Don't jump to conclusions so early, do your research and be in the loop to know more development about the same.