Say you have a presentation with a slide that includes your company’s current market capi-
talization (market capitalization = current stock price ×number of shares outstanding). The
PC you’re using to make the presentation is connected to the Web, so you write a
VBA/PowerPoint macro called GetMarketCap that retrieves your company’s current stock
price from the Web, calculates market capitalization, and puts that number in the slide.
Now you want to set up a hot drawing on the slide so that every time you pass your mouse
pointer over the drawing, the market capitalization figure gets updated with up-to-the- ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.