👉 Ready to master VBA?
- Check out my full courses: https://courses.excelmacromastery.com/
- Subscribe to the channel here: https://bit.ly/36hpTCY
- FREE CHEAT SHEET: Get the free cheat sheet on VBA arrays here: https://bit.ly/2MXsnz9
(Note: If the download page doesn't work then make sure to turn off any popup blockers)
5 More things I wish I Had Known When I Started Using Excel VBA
Hello and welcome to this Excel Macro Mastery video.
The video "5 thing I wished I knew when I started usinng Excel VBA" was very popular when I released it.
I got many requests to do more. So here it is: 5 More things I wish I Had Known When I Started Using Excel VBA.
Related Articles
VBA Inputbox – A Complete Guide (https://excelmacromastery.com/vba-inputbox/)
Using ADO section: (https://bit.ly/2Sk9Qjs)
Useful VBA Shortcut Keys:
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 + 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.
F9(or click left margin): Add a breakpoint to pause the code.
Tab: To move lines of code to the right(Indent)
Shift + Tab: To move lines of code to the left(Outdent).
Table of Contents:
00:00 - Introduction
00:28 - Complete Word
02:40 - View the Definition
06:14 - Marker 5
08:04 - Get the range from the user
09:13 - Reading from closed workbooks
10:30 - Marker 3