Join Dennis Taylor for an in-depth discussion in this video Recording a formatting macro and altering VBA code, part of Excel for Mac 2016: Macros.
- [Instructor] In this movie we're going…to create a small formatting macro…and show you how sometimes you will want to change…and streamline the VBA code that results from that…and also expand the macro to do more…than what we will have done in this recording.…In this workbook called WatchCode,…we're on a sheet called Profits.…Now, you may or may not have heard…about a feature called double accounting underlining.…Imagine it's something that you try and you say,…"I could use that often."…Let's set the stage for what it does first of all.…It's found not on the Home tab,…although that's likely where you would look.…
We see regular underlining there, double underlining there.…But if we right-click on the selected cells…and go to Format Cells, we will see under Underline,…Single, Double, Single Accounting, Double Accounting.…Here's Double.…You see how the lines are right next to the text.…And Double Accounting.…The lines move farther away from the entry.…Click OK.…That's the feature we want to use,…and we have identified it…
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