Refresh Button - Refresh Date Field

I have a simple one worksheet refreshable excel file that I simply want to add a visual aid to end user which shows the last refreshed date.

The worksheet does not refresh upon open - end user should open the file see the last date refreshed and if the end user refreshes - the date should show the current date of the refresh.

Seems simple - but I don't any program related functions, so I suspect I have to write some code. Any guidance would be appreciated. I did search the forum prior to posting and I didn't see anything the same as my question - I have no pivot tables or data tables - just a simple straight ODBC connection that fires a SQL Stored Procedure.

Basically I want Cell E2 to be populated when the end user clicks 'refresh all' on the toolbar.

Thanks in advance

In the ThisWorkbook module, paste this :

Please Login or Register  to view this content.