Updating sheet
 

I'm a newbie at VBA and i'm having big trouble with updating excel every
2 or 5 minuts.

I've tried with Application.OnTime Now + TimeValue("00:05:00"),
"Proc_Name" and the sub "Proc_name"... But i can't get it to work.

I need updating because another user is using excel-sheet 1 and filling
in data and I need to se it updated every 2 or 5 minuts.

Could someone show me the hole VBA-code, please. I'm updating from
another excel-worksheet...

Sorry, but this it my only chache to get it right....

Fu


---
Message posted from http://www.ExcelForum.com/

Updating sheet
 

sub My_Procedure

your code here

' this is one line command
Application.OnTime Now + TimeValue("00:05:00"), "my_Procedure"

end su

--
Message posted from http://www.ExcelForum.com