PowerPoint Help

[fuzzernet]

I'm trying to put a countdown timer in a presentation that will be running continuously for days. I just want a simple "Days Remaining" countdown. Everyday it decreases by 1. I've tried linking to excel but i guess i don't have the correct formula in excel, because that date only changes when excel is closed and opened again on the new day. Then, even with that PowerPoint isn't automatically updated. Any ideas?

TIA
Steve

 

[bjzielinski]

I don't have a complete answer, but maybe somebody can build on this one. This project counts the number of days until Memorial Day (also my birthday ). Create a textbox (View-Toolbars-Control Box) and put some text in it. This next step worked for me, but only because I moved the mouse, which is probably what your presentation will not do. I then created a humongous label, encompassing the whole screen. Set it to transparent and blank so you can't see it. Go to the code for this label, and add this routine:

[blue]Private Sub[/blue] Label1_MouseMove([blue]ByVal[/blue] Button [blue]As Integer[/blue], [blue]ByVal[/blue] Shift [blue]As Integer[/blue], [blue]ByVal[/blue] X [blue]As Single[/blue], [blue]ByVal[/blue] Y [blue]As Single[/blue])
Daysuntil = DateDiff("d", Date, #5/31/2004#)
TextBox1.Text = Daysuntil
[blue]End Sub[/blue]

Now whenever the mouse is moved around the label, the textbox should change.

Unfortunately there is no Slide1_Load like there is in Access, or at least not that I'm aware of. Hope this helps somebody.

Bill Zielinski
bzielinski@co.midland.mi.us
County of Midland, Michigan

 

[fuzzernet]

Thanks, I've never done anything like that b4. I created a text box with "days until" I created the label, inserted the code, but keep getting a run-time error 424 object required. I must be missing something.

 

[bjzielinski]

Which version of Powerpoint? I am using Powerpoint 2000. As I understand it, Powerpoint XP addresses objects differently.

Bill Zielinski
bzielinski@co.midland.mi.us
County of Midland, Michigan

 

[fuzzernet]

yup, version 2002, probably the culprit.

Steve

 

[fuzzernet]

bump 1 time.