Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 303
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 860
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 303
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to show time on a form NDBC Excel Discussion (Misc queries) 2 June 30th 09 11:22 AM
SHORT CUT KEY(S) TO SHOW OR HIDE SEETS IN EXCEL slow hand Excel Worksheet Functions 5 September 14th 05 02:38 AM
Paste a file short cut in VB form Sridhar Pentlavalli via OfficeKB.com Excel Programming 0 December 29th 04 01:19 PM
pls help: short cut menu doesn't show when right click mouse Yong Wah Excel Programming 1 October 23rd 03 01:56 PM
short cut menu doesn't show when right click on mouse Yong Wah Excel Programming 2 October 21st 03 01:42 PM


All times are GMT +1. The time now is 04:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"