AskAndDo timer

[obrien2003]

I have a piece of code that I need to add a 5 second timer to. If the timer expires, the YesNo question should default to YES. Any Ideas?


Here's the code as it stands...

Please Login or Register  to view this content.

[obrien2003]

Thanks. Missed that rule

btw,
Your sig?
Credo Elvem ipsum etian vivere
should read
Credo Elvem ipsum etiam vivere

[shg]

You would need to use a modeless form in lieu of the modal MsgBox. After showing the form, do

Please Login or Register  to view this content.

. If the No button is clicked, cancel the OnTime event.

[obrien2003]

Can you give me an example of the modeless form?

[VBA Noob]

Here's an example

ModelessForm.zip

VBA Noob