Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching How To Assign Keyboard Shortcuts To Macros In Excel. and this video is uploaded by Excel Campus - Jon at 2019-02-18T09:16:46-08:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [w_d6HzylJ3Q]
| Name | How To Assign Keyboard Shortcuts To Macros In Excel |
| Video Uploader | Video From Excel Campus - Jon |
| Upload Date | This Video Uploaded At 18-02-2019 17:16:46 |
| Video Discription | Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/ In this video I explain 2 ways to create keyboard shortcuts to run macros in Excel. Assigning shortcut keys to macros in your Personal Macro Workbook allows you to run the macros on any open file. Download the sample Excel file here: https://www.excelcampus.com/vba/keyboard-shortcut-run-macro/ The first way is using the Macro Options window. This can be accessed from Excel, and is easy to setup. The second way is using VBA code and the Application.OnKey method. This method requires a bit more setup work, but does have some distinct advantages. Which method is better? Watch the video to find out. :-) Please leave a comment below with any questions or suggestions. Related videos & posts: How to Create Your Personal Macro Workbook: https://youtu.be/rD2-mSbTuL0 How to Run Event Macros based on User Actions: https://youtu.be/VJWBOuNXHB4 Add Macro Buttons to the Ribbon Toolbar: https://youtu.be/dmdolFcS-fI How to Enable the Developer Tab: https://youtu.be/JLQ8OuW0FlY Best keyboards for Excel Shortcuts: https://www.excelcampus.com/keyboard-shortcuts/best-keyboards-for-excel-keyboard-shortcuts/ 18 Excel Shortcuts for 2018: https://www.excelcampus.com/vba/excel-vba-macro-shortcuts/ 00:00 Introduction 00:40 Macro Options Window 02:51 Macro Options Window Pros and Cons 04:45 Onkey Method 09:55 Pros and Cons 12:51 Conclusion [w_d6HzylJ3Q] |
| Category | Education |
| Tags | excel | excel campus | excel tutorial | microsoft excel | keyboard shortcuts | visual basic for applications | excel campus macros | keyboard shortcuts for excel | keyboard shortcuts for excel macros | assign keyboard shortcuts to macros | run macro with keyboard shortcut | create keyboard shortcuts for macros | create keyboard shortcuts for macros in Excel | create keyboard shortcuts in VBA | vba application.onkey | vba application.onkey method |
