How to use Regular Expressions with Excel VBA (Part 1)

How to use Regular Expressions with Excel VBA (Part 1)

In this video I am covering Regular Expressions. These are a very powerful feature used in most programming languages.

Don't worry if you've never heard of them. In this video I will show you why you need Regular Expressions and how important they are.

FREE CHEAT SHEET: Get the free cheat sheet on VBA arrays here: (https://bit.ly/2MXsnz9)

Excel VBA Training
The Excel VBA Handbook Course(https://TheExcelVBAHandbook.com)
Webinar Archives - 60+ Hours of VBA training(https://excelmacromastery.com/excel-vba-webinars/)

Related Links:
The Ultimate Guide to Excel VBA String Functions(https://excelmacromastery.com/vba-string-functions/)
The VBA Like Operator(https://bit.ly/342HAnR)
The Instr Function(https://bit.ly/2p1k4ZA)
Related Webinar Replays(VBA Vault Members only):
How to use VBA String Functions(https://excelmacromastery.com/vba-strings-video/)

Free Excel VBA Resources
Excel VBA Articles (https://excelmacromastery.com/vba-articles/)

Useful VBA Shortcut Keys:
View the Immediate Window: Ctrl + G
Tab: To move lines of code to the right(Indent).
Shift + Tab: To move lines of code to the left(Outdent).

Shift + F2: Get the definition of the item under the cursor.
Ctrl + Shift + F2: Go to the last cursor position.
Ctrl + Space: AutoComplete Word.
Alt + F11: Switch between Excel and the VBA Editor.
Ctrl + G: view the Immediate Window
Ctrl + R: View the Project Explorer Window.
Ctrl + Shift + 8(or Ctrl + *): Get the current region on a worksheet.
F4: View the Properties Window.
F5: Run the code from the current sub.
F8: Step into the code.
F9(or click left margin): Add a breakpoint to pause the code.

Видео How to use Regular Expressions with Excel VBA (Part 1) канала Excel Macro Mastery