Join Dennis Taylor for an in-depth discussion in this video Creating interactive macros and stepping through macros, part of Excel for Mac 2016: Macros.
- [Instructor] In this workbook called StateFile,…there are sheet tabs for the 10 largest states,…and eventually, we'll be having a tab for every state.…And already, a macro has been recorded…that does sorting on the different state tabs.…Each of this tabs looks very similar,…but they've got a different number of rows,…and eventually, we will expand the macros…to do other things, as well.…But we're also setting this up for certain users…who don't necessarily know a whole lot about Excel.…We want to be able to prompt them to use the right sheet…or to be able to jump to this sheet or that sheet.…
There are lots of different ways to do that in Excel,…but you can also create VBA code…that prompts the user to type in an entry,…and then at entry is used in the remainder of the code…to either go to a certain location or take a certain action.…Now, when you're preparing VBA code,…maybe you've gotten it out of a book,…you've found it on a website.…What you typically do not do…is something I'm about to do here.…On this worksheet called totals, the very first sheet,…
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