Join Dennis Taylor for an in-depth discussion in this video Running a macro from a keystroke shortcut, part of Excel for Mac 2016: Macros.
- [Instructor] When you record a macro,…you have the option of using a keystroke shortcut…so that you can later play back the macro…by using the keystroke shortcut.…And it's a fast method and particularly appealing…as you're getting started with macros,…but it does have some limitations.…Sometimes you forget which keystroke shortcut is which.…You are limited to using only the uppercase…and lowercase letters and even some of them…are not available.…In this workbook called Playback Shortcut Keys,…the first worksheet is called Current Staff.…There's some date formats in column F.…
Those are quite common, month, day, year.…But I prefer to have a four-digit year.…On the Home tab in the Ribbon,…in the Number group here, the date options…include short date, which uses that two-digit year,…and long date, which is way too long for me.…I want to use that shorter version,…but one that has a four-digit year.…So, I'm going to record a macro here.…I'll go to the Developer tab, Record Macro.…I'll call this Four Digit...…By the way, you cannot start a macro with a number…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Working with existing macros
- Creating macros with the recording process
- Viewing and modifying VBA code
- Running a macro from the Developer or View tabs
- Running a macro from a keystroke shortcut
- Running a macro from an object or picture
- Creating and updating the Personal macro workbook
- Recording a formatting macro
- Expanding a macro with an IF statement
- Creating interactive macros
- Stepping through macros