MS Word Work Hack: Cheat page limit requirements & add extra content/data within a pop-up window
This is one of my favorite work hacks that I use when someone gives me a page limit in Microsoft Word, but I just have more content than I can fit. Pictures, especially graphs and tables take up so much space, so I can have the best of both worlds by including them, while not taking up space!
It requires just a few steps and one line of VBA. Even if you aren't tech savvy, if you can type in "UserForm1.Show", that's all the coding you need! Just follow along and you will have your own version in no time.
Essentially, we just create a label, button, etc. and create a function to pop up a form that includes extra content (in my case I demonstrate a time series graph that would otherwise take up half the page) any time it is clicked on. You can include as many pop-ups as you want. 1, 5, 30 pop-ups? Yep!
Next time someone tells you "I want a one page report with lots of detail", let 'em have it!
I want to thank all my viewers and subscribers. I really appreciate all of you!
VIDEO TIMELINE
Introduction: 0:00
Overview: 0:06
Add Developer tab: 0:38
Add control (e.g., label, button) to click on for pop-up: 0:55
Create the pop-up form with content: 1:46
Move the control (label in my case) to desired location: 3:05
Test to confirm it works: 4:51
Conclusion: 5:28
End scene: 5:40
