I have sheet1 cell C1 that I wish to populate with values.
The values are in sheet2 - in the range "values" - this is a single column of data.
I think some VBA is required.
I would like the first value from "values" to be copied into sheet1 cell C1, this value needs to reside there for a specified amount of time say 10 seconds and then be replaced by the second value from "values" a pause and then the third value is put into cell C1 etc. etc.
The standard pause period needs to be controlled by the user who would specify the number of seconds delay in sheet1 cell A1.
There also needs to be a command button to temporally halt the feed process.
The value in C1 governs the display of a graph of data.
I would like the graphs to be displayed automatically after allowing a sufficient amount of time to look at each graph. Where a graph has unexpected results - the use of a button to temporally halt the process would be usefull. Clicking the button again would then continue with the graph displays i.e.feeding data from "values" to cell C1.