Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
show form for very short time
Is there a way to flash a short message using a form for a time far shorter
than a second? Thanks Bill Kuunders |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
show form for very short time
Hi Bill,
Bill Kuunders wrote: Is there a way to flash a short message using a form for a time far shorter than a second? Yes - you can use the GetTickCount API function to do something like that: Private Declare Function GetTickCount Lib "kernel32" () As Long Sub demo() Dim lCount As Long frmMessageBox.Show vbModeless lCount = GetTickCount Do While GetTickCount < (lCount + 500) DoEvents Loop Unload frmMessageBox End Sub -- Regards, Jake Marx www.longhead.com [please keep replies in the newsgroup - email address unmonitored] |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
show form for very short time
Thank You very much Jake.
"Jake Marx" wrote in message ... Hi Bill, Bill Kuunders wrote: Is there a way to flash a short message using a form for a time far shorter than a second? Yes - you can use the GetTickCount API function to do something like that: Private Declare Function GetTickCount Lib "kernel32" () As Long Sub demo() Dim lCount As Long frmMessageBox.Show vbModeless lCount = GetTickCount Do While GetTickCount < (lCount + 500) DoEvents Loop Unload frmMessageBox End Sub -- Regards, Jake Marx www.longhead.com [please keep replies in the newsgroup - email address unmonitored] |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to show time on a form | Excel Discussion (Misc queries) | |||
SHORT CUT KEY(S) TO SHOW OR HIDE SEETS IN EXCEL | Excel Worksheet Functions | |||
Paste a file short cut in VB form | Excel Programming | |||
pls help: short cut menu doesn't show when right click mouse | Excel Programming | |||
short cut menu doesn't show when right click on mouse | Excel Programming |