more on countdown clock

[Fred Dagg]

I want to countdown to an event, ie Christmas. I want to display days;
hours: minutes:seconds. I want to use the system clock so the countdown
doesn't reset each time the presentation is loaded. Is this possible?

Thanks again.

 

[Bill Dilworth]

Yes Fred, there is a way.

1) Do you know any VBA or coding?
2) Will you have control on the computer(s) that will run this.
3) Will this be distributed?

You will need to run a macro on the presentation to calculate the clock, but
the macro may be blocked by security settings.

--
Bill Dilworth
A proud member of the Microsoft PPT MVP Team
Users helping fellow users.
http://billdilworth.mvps.org
-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
vestprog2@ Please read the PowerPoint FAQ pages.
yahoo. They answer most of our questions.
com www.pptfaq.com
..

 

[Fred Dagg]

Thanks Bill, I do a bit of VB and I've designed a form that does exactly
what I want. How do I get the form from the VBA Project (within the
presentation) to display on the slide?
Thanks again.

 

[Bill Dilworth]

Ok, that is a very good start.

Make a Module with a subroutine that opens your time-keeping VBA form.
Then use an action setting to fire the subroutine.



In module:
Sub ParsleySageRosemary()
frmMyForm.Show
End Sub



In presentation:
Right click on shape that you want to start the clock.
Select Action Settings
Select Mouse Click tab
Select Run Macro button
Select ParsleySageRosemary in the pulldown
OK out of there

--
Bill Dilworth
A proud member of the Microsoft PPT MVP Team
Users helping fellow users.
http://billdilworth.mvps.org
-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
vestprog2@ Please read the PowerPoint FAQ pages.
yahoo. They answer most of our questions.
com www.pptfaq.com
..

 

[Steve Rindsberg]

Thanks Bill, I do a bit of VB and I've designed a form that does exactly
what I want. How do I get the form from the VBA Project (within the
presentation) to display on the slide?

Forms don't appear on slides, but if you show the form, it'll appear above the
slide. You could create a button or other shape and assign it an Action
Setting of Run Macro: ShowMyForm, having first created the macro in the IDE:

Sub ShowMyForm()
MyForm.Show
Unload MyForm
End Sub

 

[Fred Dagg]

Okay, thanks Bill and Steve. I'm getting there and so far it works with a
shape after clicking the mouse BUT, is there a way to automate the macro to
run as soon as the slide appears and the macro stops when the slide's time
has expired? This is the final step. Thanks again.

 

[Steve Rindsberg]

Sub ParsleySageRosemary()

frmMyForm.Show
End Sub

OoohOooh, I know I know .... that's 'cause the form's got a Thymer on it?

 

[Steve Rindsberg]

Okay, thanks Bill and Steve. I'm getting there and so far it works with a
shape after clicking the mouse BUT, is there a way to automate the macro to
run as soon as the slide appears and the macro stops when the slide's time
has expired?

For this you'd need event handling.

Make PPT respond to events
http://www.rdpslides.com/pptfaq/FAQ00004.htm

You'd trap the event that occurs when the presentation moves to a new slide and
in the event handler, display your form. Bear in mind that forms are by
default modal, meaning that while they're displayed, nothing else happens in
the app behind them. If that's a non-starter, you can display non-modal forms
in PPT 2000 and up.

If the form is non-modal, you may be able to trap the next new slide event and
cycle through the forms collection; if your form is a member of the collection,
hide and unload it.

 

[Bill Dilworth]

I knew someone well seasoned would get it.

OoohOooh, I know I know .... that's 'cause the form's got a Thymer on it?

 

[Steve Rindsberg]

A tarragon of virtue, no cinnermon, I.

I knew someone well seasoned would get it.

 

[Fred Dagg]

okay, okay. But I can't find the timer control. It doesn't appear on my
toolbox. Alternatively, can i put 'code' directly into the textbox?

thanks all

 

[Fred Dagg]

All Done. Thanks everyone. Shyam Pillai's download page gave me the auto
events info and with some [very] minor adjustments, the slide show does
exactly what I want it to do. Thanks again everyone.