Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

In this video I share 8 of my favorite keyboard shortcuts for the Visual Basic (VBA) Editor for Excel.

I list the shortcuts for both the Windows and Mac versions of Excel. The shortcuts will work in Excel 2003 to 2016 (Office365) for Windows, and Excel 2016 for Mac. The updated version (currently pre-release) is required for the Mac version. See this video for details. https://youtu.be/eRhp1Og269E

Here are the shortcuts mentioned in the video
0:09 - Open VB Editor or Excel - Alt+F11 (Mac: Fn+Opt+F11)
0:34 - Run a Macro - F5 (Mac: F5)
0:55 - Step Through Code - F8 (Mac: Shift+Cmd+I)
1:34 - Open Immediate Window - Ctrl+G (Mac: Ctrl+Cmd+G)
2:14 - Complete Word - Ctrl+Space (Mac: Ctrl+Space)
3:14 - Delete Line - Ctrl+Y (Mac: Cmd+Y)
3:43 - Quick Info - Ctrl+I (Mac:Cmd+I)
4:17 - Intellisense - Ctrl+J (Mac:Cmd+J)

Please share your favorite keyboard shortcuts for the VB Editor in the comments below.

This week I am running a free webinar on "The 7 Steps to Getting Started with Macros & VBA". In this free training session you will learn how to write your first macro and everything you need to know to get started automating your Excel tasks.

Please click the link below to register. It's free!
https://www.excelcampus.com/free-macros-webinar

Other articles & videos mentioned
5 Ways to use the Immediate Window: https://www.excelcampus.com/vba/vba-immediate-window-excel/
New VB Editor for Excel 2016 for Mac: https://youtu.be/eRhp1Og269E
Video Series on The Personal Macro Workbook: https://youtu.be/rD2-mSbTuL0