👉 Ready to master VBA?
- Check out my full courses: [ Ссылка ]
- Subscribe to the channel here: [ Ссылка ]
- FREE CHEAT SHEET: Get the free cheat sheet on VBA arrays here: [ Ссылка ]
(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 ([ Ссылка ])
Using ADO section: ([ Ссылка ])

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

свернуть