How would I create a routine that runs every 15 mins?
 

I will have a userform open on worksheet MASTER
I want to make a routine that every 15 minutes, it will append a new record
in a non selected worksheet (Worksheet 15minrecord), then paste some
numbers in, and then return to the selected worksheet.

How would I do this? What are the chances that it will interfer with what I
am doing in MASTER with my userform?

Thanks
Bruce

How would I create a routine that runs every 15 mins?
 

Bruce,

You can use the OnTime method to schedule a procedure to execute at a
specific time. See www.cpearson.com/excel/ontime.htm for more details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"BruceJ" wrote in message
news:bGzlb.364$e01.541@attbi_s02...

I will have a userform open on worksheet MASTER
I want to make a routine that every 15 minutes, it will append a new
record
in a non selected worksheet (Worksheet 15minrecord), then paste some
numbers in, and then return to the selected worksheet.

How would I do this? What are the chances that it will interfer with what
I
am doing in MASTER with my userform?

Thanks
Bruce

How would I create a routine that runs every 15 mins?
 

Look at Chip Pearson's page on the use of Application.Ontime

http://www.cpearson.com/excel/ontime.htm

ontime is not preemtive, so it will not fire while your userform is up
(modal) or excel is busy.

--
Regards,
Tom Ogilvy


"BruceJ" wrote in message
news:bGzlb.364$e01.541@attbi_s02...

I will have a userform open on worksheet MASTER
I want to make a routine that every 15 minutes, it will append a new
record
in a non selected worksheet (Worksheet 15minrecord), then paste some
numbers in, and then return to the selected worksheet.

How would I do this? What are the chances that it will interfer with what
I
am doing in MASTER with my userform?

Thanks
Bruce