Updating sheet

  • Thread starter Thread starter Fu Manchu
  • Start date Start date
F

Fu Manchu

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
 
sub My_Procedure

your code here

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

end su
 
Back
Top