copy a cell value every hour in a specific cell

**bob2007** · 10-14-2008, 01:21 AM

Hi,

I got an application where a cell value is being updated every 3-4 seconds. I wish to do a report and copy this cell value every hour in a specific cell.
Many thanks for any help.

Bob

**xld** · 10-14-2008, 04:40 AM

Look at Ontime in VBA help, that will get you going.

**bob2007** · 10-14-2008, 05:37 AM

Thank you for your prompt reply. Could you give me a link where I could find the VBA help Ontime. I have only a dial-up connection and it`s a battle to search on the site.

Thanks.

Bob

**xld** · 10-14-2008, 09:01 AM

Well a better place to look is here

**bob2007** · 10-15-2008, 12:07 AM

Thank so you so much. Ok I understand the ontime procedure. The macro should you read like this

Please Login or Register  to view this content.

This stores the time to run the procedure in the variable RunWhen, two minutes after the current time.

The procedure that will be called by OnTime,

Please Login or Register  to view this content.

My question is :

I want to copy the content of cell A1 to cell A2 , I am writing the copy function as code, but I`m getting error each time. Your help would be greatly appreciated.
Note: I`m learning VBA now.

Bob

**xld** · 10-15-2008, 03:16 AM

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

You must ensure that RunWhen is a global variable in a standard code module

**bob2007** · 10-15-2008, 07:32 AM

Hi,

I believe I`m doing something wrong. I got the message `The_Sub,Schedule:=Time' cannot be found when I run the startTimer.
Thanks again for your time.
Bob

**xld** · 10-15-2008, 09:28 AM

No, it was my error

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

**bob2007** · 10-16-2008, 06:30 AM

Wonderful. Thank you so much xld. Ok the code is copying cell A2 to cell A1 after 4 seconds. Now, I wish to modify the code so that it copies the content of cell A2 onto cell A3 ONLY afterr 8 seconds.
Thank again for your kind contribution.

Bob

**xld** · 10-16-2008, 06:47 AM

Setup a separate OnTime with a separate time variable and a separate procedure.

**bob2007** · 10-17-2008, 03:32 AM

Thanks xld. However, I still have a problem. I don`t wish that the value copied to the cell changed when the original cell, A2, is changing. The A2 cell value is being updated all the times.
Thanks again for your help.

Bob

**xld** · 10-17-2008, 04:54 AM

Sorry, I don't understand what you are saying here.

**bob2007** · 10-17-2008, 05:03 AM

Ok, Let me explain. The value in cell A2 is being updated all the times. I want to copy its current value at time x onto cell A3, then after time y its current value onto cell A4 and so on.
Thanks.

Bob