Ken1000
11-05-2007, 07:47 PM
Hi. Could you possibly help me to create proper VBA code that would read an interval from a cell, and then using that increment, start running a specified macro from then on, at that increment?
For instance, say cell C3 on Sheet1 is where that timing interval is stored. If Cell C3 has 15 in it, it means the timing interval is every 15 minutes.
(The timing interval may change from day to day.)
I need VBA code to read that value in cell C3, and immediately after reading it, run macro "XYZ", and then every interval after that, run the same macro, until the workbook is closed. (In this case, every 15 minutes.)
I have the following code, but do not now how to get the original calling macro to run macro "XYZ" at the specified interval, repeatedly.
xinterval = Range("Sheet1!C3").value
'Run XYZ immediately and then, continuoslu, at value of xinterval
Could you please help me by sharing code that would do this?
Thank you very, very much.
Ken1000
For instance, say cell C3 on Sheet1 is where that timing interval is stored. If Cell C3 has 15 in it, it means the timing interval is every 15 minutes.
(The timing interval may change from day to day.)
I need VBA code to read that value in cell C3, and immediately after reading it, run macro "XYZ", and then every interval after that, run the same macro, until the workbook is closed. (In this case, every 15 minutes.)
I have the following code, but do not now how to get the original calling macro to run macro "XYZ" at the specified interval, repeatedly.
xinterval = Range("Sheet1!C3").value
'Run XYZ immediately and then, continuoslu, at value of xinterval
Could you please help me by sharing code that would do this?
Thank you very, very much.
Ken1000