| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I automatically refresh the time on a worksheet?
I want to automatically refresh the time on a worksheet every 5 minutes. I
know how to insert Now() into a cell but am not sure how to get it to update. The second part of the task is to then run a macro when a specific time is reached. I have no idea how to do this. Basically, I want something to execute each day at 15:00. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I automatically refresh the time on a worksheet?
Use OnTime event macros.
See: http://www.cpearson.com/excel/ontime.htm -- Gary''s Student - gsnu200728 "CraigJ" wrote: I want to automatically refresh the time on a worksheet every 5 minutes. I know how to insert Now() into a cell but am not sure how to get it to update. The second part of the task is to then run a macro when a specific time is reached. I have no idea how to do this. Basically, I want something to execute each day at 15:00. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I automatically refresh the time on a worksheet?
What?
"Gary''s Student" wrote: Use OnTime event macros. See: http://www.cpearson.com/excel/ontime.htm -- Gary''s Student - gsnu200728 "CraigJ" wrote: I want to automatically refresh the time on a worksheet every 5 minutes. I know how to insert Now() into a cell but am not sure how to get it to update. The second part of the task is to then run a macro when a specific time is reached. I have no idea how to do this. Basically, I want something to execute each day at 15:00. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I automatically refresh the time on a worksheet?
Click on the link to see instructions that explain what you need to do.
CraigJ wrote: What? "Gary''s Student" wrote: Use OnTime event macros. See: http://www.cpearson.com/excel/ontime.htm -- Gary''s Student - gsnu200728 "CraigJ" wrote: I want to automatically refresh the time on a worksheet every 5 minutes. I know how to insert Now() into a cell but am not sure how to get it to update. The second part of the task is to then run a macro when a specific time is reached. I have no idea how to do this. Basically, I want something to execute each day at 15:00. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can i get advanced filter to automatically refresh | Excel Worksheet Functions | |||
| Data Query will not Refresh automatically | Excel Worksheet Functions | |||
| Refresh workbook automatically | Excel Worksheet Functions | |||
| If someone makes a change does this automatically refresh? | Excel Discussion (Misc queries) | |||
| Formula do not refresh automatically | Excel Discussion (Misc queries) | |||
Linear Mode
