From the course: Access 2019: Building Dashboards for Excel

Unlock the full course today

Join today to access over 24,400 courses taught by industry experts.

Create macros that navigate

Create macros that navigate

From the course: Access 2019: Building Dashboards for Excel

Start my 1-month free trial Buy for my team

Create macros that navigate

“

- [Instructor] Some of the easiest macros you could ever create are to navigate. Let's build some macros that navigate to our pivots. We're giving a visual display of our data, but we want to also give them the ability to just jump and point to things like department minutes and averages so they can see the actual values, maybe even to department percentages and maybe to that percentage over time that we built. So let's go ahead and go to our dashboard and create those navigation macros. Okay, I'll go to Developer. I'll choose Record Macro, and I'll name this one nav to percent over time. I'm going to say navigates to percentage over time. Click Okay and then I'll click on Percent Over Time and then I'll stop recording. Okay, let me go back over to my dashboard. Go to my Macros, choose my Nav and then run it; perfect. Now I'll go back to my dashboard. Okay, let's record another one. And we'll call this one nav to…

Contents