View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tomski[_25_] Tomski[_25_] is offline
external usenet poster
 
Posts: 1
Default Ontime method, quick question.


Hi,

I need to run "getprice" 3 times during the day. The way I will do it
at the moment would be to use the line shown below 3 times with the
different times.

Application.OnTime TimeValue("06:00:00"), "getPrice"

I was wondering if it was possible to just use one line, kind of like
that shown below, which I know won't work, but shows what I want to
do.

Application.OnTime TimeValue("06:00:00"),TimeValue("12:00:00"),
TimeValue("16:00:00"), "getPrice"


Thanks

Tom


--
Tomski
------------------------------------------------------------------------
Tomski's Profile: http://www.excelforum.com/member.php...o&userid=26824
View this thread: http://www.excelforum.com/showthread...hreadid=570279