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

[BruceJ]

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

 

[Chip Pearson]

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 (e-mail address removed)

 

[Tom Ogilvy]

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.