View Single Post
 
Old 10-28-2013, 09:58 AM
jason66 jason66 is offline Windows 8 Office 2010 32bit
Novice
 
Join Date: Oct 2013
Posts: 6
jason66 is on a distinguished road
Default VBA Counters in Powerpoint

Did you ever get a solution to this question?

I have a very similar quest - I want to show how much potential benefit has been lost through not making a change - so I can say "Look at the totaliser on each slide, this shows the money that's been lost because you didn't make the change this presentation is trying to convince you to make"

So far I can make the code to do what I want in Excel, I thought I could just embed that Excel in a slide but that doesn't work. Excel won't update when embedded so all I get is a static cell in my PowerPoint.

I then thought I could use the VBA from Excel and put that into PowerPoint but I ran out of talent and can't figure it out :-(

Any words of wisdom/encouragement?

Oh and the animated idea is OK but I could conceivably be running the slides for several hours, even all day - so it needs to be a sensible coded solution I think. The rate of "lost" money is something like £76.10 per minute - so I need something that updated with 76.10 every 60 seconds in a box I can put a currency sign in front (GBP or £).

All ideas gratefully received.

J
Reply With Quote