Join Dennis Taylor for an in-depth discussion in this video Expanding macro functionality with the IF statement, part of Excel for Mac 2016: Macros.
- [Narrator] In the previous movie…we recorded the macro to apply double accounting underling,…a feature that you've decided is going to be needed often,…you want a key stroke short cut for it…but now the thought occurs to you,…unlike other buttons on the home tab,…bold which is an on off or a toggle button.…So is italics, so is underline, standard underlining.…Let's make double accounting go in that same direction.…Now we have a macro already written.…If you didn't watch the previous macro…or didn't go through the steps…of creating the macro,…a back up copy is available.…
Let's go to the developer tab in the ribbon.…Far left button visual basic…and for the watch code workbook,…expand it if necessary,…go to its modules and in module one,…heres a copy of the macro that was created…in the previous movie…and it all does is apply double accounting underlining.…So the question occurs, how can we change…this code so it's an one off kind of macro,…a toggle switch so to speak?…Let's go back and do the following.…Record another macro that turns off double accounting.…
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