Microsoft Excel - Deleting fields?

Question

How do you set a range of fields to automatically refresh or delete their contents at a certain time regularly?

Answer 1

How to best accomplish the refreshing or clearing of a range of cells depends on how the Excel workbook will be used.  

If it will be left open and visible on the desk top most of the time and it is important for the clearing to show even when there is no activity, then you will need to use a timer that is set to check the time every 55 seconds and to refresh or clear fields if the time (to the minute) is an update time.  You will also probably need to refresh or clear the fields when the workbook is first opened.

Otherwise, it would be simpler to maintain a last updated time in a cell somewhere in one of your worksheets.  Then each time there is any activity (i.e. in the Workbook_SheetSelectionChange event,) check to see if a refresh or clear is due.

For either method you will want to place the code to refresh or clear the cell in a separate subroutine.  And creating a named range that include just the cells to be maintained would make that subroutine very simple.

This has been a fairly high level discussion.  If you are looking for code, provide more detail of what cells, what refreshing or clearing you want, and when you want it and we will see what we can do.  If you are going to ask for that, you will need to extend your question to have a chance of getting results.