need help with a timer

[ionaman]

In the attached excel file, I am wondering is anyone able to put a time
on it for me. When the Hint button is pressed a text GUI appears. I wa
wondering does anyone know how to just have this GUI appear for 3
seconds. all help and comments appreciated

Attachment filename: latestversion.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=51011

 

[Bob Phillips]

Reprint from your other post in .Misc group

Here is an example of a timed msgbox.

Dim cTime As Long
Dim WSH As Object

Set WSH = CreateObject("WScript.Shell")
cTime = 30 ' 30 secs
Select Case WSH.Popup("Don't do it!", cTime, "Hint", vbOKCancel)
Case vbOK
MsgBox "You clicked OK"
Case vbCancel
MsgBox "You clicked Cancel"
Case -1
MsgBox "Timed out"
Case Else
End Select


As you can see, it can be OK, Cancel or timed out.


Please do not post multiple requests.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Tom Ogilvy]

Look at Chip Pearson's page on using Application.Ontime

http://www.cpearson.com/excel/ontime.htm