Thanks Chip,
I was looking for how to actually SET the varible. Bob Phillips gave me
the info I needed for that. I got to your site last week, so I had already
gotten that portion figured out, I just needed the next 15 min (based on a
1/4 hour)
Thanks
Bruce
"Chip Pearson" wrote in message
...
Bruce,
You can use the OnTime method to schedule a macro to execute. See
www.cpearson.com/excel/ontime.htm for example code.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"BruceJ" wrote in message
news:%Henb.32171$275.58288@attbi_s53...
I am looking to find out how to set a timer to the next 15 min interval
(On
the 1/4 hour)
What would be the best way to set a varible (NxtTime) to the next 1/4
hour?
I need to have something run at each 15 minutes on the quater hour, how
can
I figure out the NEXT 1/4 hour? I know I will add 900 seconds after
that,
but I am not sure how to figure out the next 1/4 hour....
Thanks
Bruce