MS Excel - How to refresh a cell automatically every 5 seconds?
<p>I have a cell in my Excel sheet and I need this cell to be refreshed every 5 seconds.</p>

<p>MS Excel itself enables to set refreshing but it is only every 1 minute and that is insufficiently too long..</p>

<p>I need some code in VBA or macro set to be run every 5 seconds and do exactly what would be done if I clicked Refresh every 5 seconds as it is shown here:</p>

<p><a href="https://i.stack.imgur.com/zrusr.gif" rel="nofollow"><img src="https://i.stack.imgur.com/zrusr.gif" alt="Refresh"></a></p>

<p>Somehow I didn't find any example of that I have absolutely no clue how to do that as I don't know how to work in VBA..</p>