8 Awesome Keyboard Shortcuts For The Vba Editor In Excel скачать в хорошем качестве

8 Awesome Keyboard Shortcuts For The Vba Editor In Excel

Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint... 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.    • Updates To The Visual Basic Editor For Exc...   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-macr... Other articles & videos mentioned 5 Ways to use the Immediate Window: https://www.excelcampus.com/vba/vba-i... New VB Editor for Excel 2016 for Mac:    • Updates To The Visual Basic Editor For Exc...   Video Series on The Personal Macro Workbook:    • How to Create a Personal Macro Workbook in...