Don't confuse VB with VBA. They are not the same thing.
https://www.theregister.co.uk/2017/0...ore_scenarios/
I heard some undocumented rumors about VBA going away sometime in 2020. Is this true?
Don't confuse VB with VBA. They are not the same thing.
https://www.theregister.co.uk/2017/0...ore_scenarios/
TIPS FOR FINDING EXCEL SOLUTIONS
1. Use the built-in Help that comes with Excel/Access
2. Use the Search functionality on this board
3. A lot of VBA code can be acquired by using the Macro Recorder.
"Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"
VBA is not going away, however, no improvements are slated to be made to the UI. The Object Model will continue to be updated as new features are released though.
There are investments being made in the JavaScript API's, which will enable extensibility on all endpoints. For that, see: ScriptLab. That's not at parity with VBA at this point, but new additions are made every week.
HTH
Smitty
Every once in a while, there's a sudden gust of gravity...
Give us your suggestions on what Excel should do next @ Excel User Voice!
Mr. Excel HTML Maker - Post a shot of your sheet
Like this thread? Share it with others