View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kash Kash is offline
external usenet poster
 
Posts: 59
Default On time from cell time

Hi, I am using below code to do a task on a particular time as in a cell..

Application.OnTime TimeValue(CDate([Totals!O2])), "Assign"

But this takes the time whatever is there in the cell while workbook is
being opened, but I need to trigger a macro on time even after editing the
time in the cell.

Please help..

Thanks.