Join Nate Makdad for an in-depth discussion in this video Editing VBA code, part of Creating Interactive Dashboards in Excel 2013.
- Recording a macro gives you a pretty good start,…but by cleaning up the Visual Basic code,…we'll be able to customize our macro…and make it work for all of our pivot tables…and each of our buttons.…We primarily want to edit the code manually…to remove the extra steps that Excel may have recorded,…and again customize that code so we can add it…to all the buttons in our dash board.…So to do this, we're gonna get started…by creating some place holders for our other macros,…so we're gonna add six total buttons to the report,…to cover, you know, Agency, Division, Work Location,…Borough, the Degree and the Post Type.…
We're gonna leave out the Snapshots.…And then we'll also add another button…to kind of clear out our dimensions.…We could do, kind of, what we just did with the Agency…for each of these different dimensions,…but I think this is a little bit faster…because after we create our place holders…we're gonna go ahead, clean up our code,…and then we'll be able to just copy and paste that code,…make a slight variation, and paste it…
- Recognize three dimensions of a PivotTable.
- Summarize four design tips.
- Identify the two default sections for values in Excel.
- Explain how to add slicers in a single column.
- Recall the shortcut used to insert a hyperlink.
- Determine the location to look when you have an error while pasting data.