Why Office Scripts Won't Replace VBA

👉 Ready to master VBA?
Check out my full courses: https://courses.excelmacromastery.com/
Subscribe to the channel here: https://bit.ly/36hpTCY

Why Office Scripts Isn't a Replacement for VBA

In my last video "Will Python Kill VBA in 2021?"(   • Will Python Kill Excel VBA?  ) many people asked about Office Scripts/Typescripts: "Isn't this the VBA replacement?" Even though Office Scripts is similar to VBA in many ways it is not a replacement. In this video, I explain why this, and I also provide a definite answer to the question "What is the future of Excel VBA?"

Many thanks to Brad Yundt(Excel MVP) whose Quora answers provides great information on the history of Office Scripts as well as the future of VBA. These are two great answers by Brad:
Which is the most probable language to replace VBA and why?(https://bit.ly/3kxUcP2)
Is VBA going to die?(https://bit.ly/3ezxp1M)

#OfficeScripts #lTypeScript #Excel

Useful VBA Shortcut Keys
========================

Debugging:
Compile the code: Alt + D + C OR Alt + D + Enter
Run the code from the current sub: F5
Step into the code line by line: F8
Add a breakpoint to pause the code: F9(or click left margin)

Windows:
View the Immediate Window: Ctrl + G
View the Watch Window: Alt + V + H
View the Properties Window: F4
Switch between Excel and the VBA Editor: Alt + F11
View the Project Explorer Window: Ctrl + R

Writing Code:
Search keyword under cursor: Ctrl + F3
Search the word last searched for: F3
Auto complete word: Ctrl + Space
Get the definition of the item under the cursor: Shift + F2
Go to the last cursor position: Ctrl + Shift + F2
Get the current region on a worksheet: Ctrl + Shift + 8(or Ctrl + *)
To move lines of code to the right(Indent): Tab
To move lines of code to the left(Outdent): Shift + Tab
Delete a Line: Ctrl + Y(note: this clears the clipboard)

Table of Contents:

00:00 - Introduction
00:25 - The origin of Office Scripts
01:54 - What is Office Scripts?
02:37 - Advantages of Office Scripts
03:41 - The Future of VBA
04:29 - How Office Scripts are used
05:19 - Key Differences
07:08 - Debugging in Office Scripts
07:32 - Converting VBA to TypeScript