#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 189
Default Timer in VBA

hi,
Does anybody know how I can add a Timer to userForm in VBA?.I couldn't find
it in VBA's toolbox.I need to close a form like 5 seconds after appearing.any
help?
thanx
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default Timer in VBA

Look here for an example http://www.xldynamic.com/source/xld.xlFAQ0007.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"peyman" wrote in message
...
hi,
Does anybody know how I can add a Timer to userForm in VBA?.I couldn't
find
it in VBA's toolbox.I need to close a form like 5 seconds after
appearing.any
help?
thanx



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 189
Default Timer in VBA

thanx Bob,useful as usual!!

"Bob Phillips" wrote:

Look here for an example http://www.xldynamic.com/source/xld.xlFAQ0007.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"peyman" wrote in message
...
hi,
Does anybody know how I can add a Timer to userForm in VBA?.I couldn't
find
it in VBA's toolbox.I need to close a form like 5 seconds after
appearing.any
help?
thanx




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
Timer Brandon H Excel Discussion (Misc queries) 5 August 9th 07 01:54 PM
Timer Vijay Excel Worksheet Functions 1 April 6th 07 11:00 AM
Countdown Timer Saxman Excel Discussion (Misc queries) 1 February 6th 07 09:55 AM
Lap-timer kabildgaard Excel Discussion (Misc queries) 0 August 11th 06 03:26 PM
Stopping a Timer / Running a timer simultaneously on Excel Paul23 Excel Discussion (Misc queries) 1 March 10th 06 12:08 PM


All times are GMT +1. The time now is 02:19 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"