ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Time (https://www.excelbanter.com/excel-programming/324344-time.html)

tjh

Time
 
Hello,

Is it possible to store the Date and time that a command button was last
pushed or run. I would like a label box on a form to state the date and time
that the command button for that form was last run. I would also like this
information to save even after the computer has been turned off,and to
display the last time the command was run, maybe weeks later. Also, this
macro is stored in an Add-In, it is not assigned to any particular
spreadsheet.

galimi[_2_]

Time
 
You can store that data on one of the hidden sheets in the XLA

http://HelpExcel.com

"tjh" wrote:

Hello,

Is it possible to store the Date and time that a command button was last
pushed or run. I would like a label box on a form to state the date and time
that the command button for that form was last run. I would also like this
information to save even after the computer has been turned off,and to
display the last time the command was run, maybe weeks later. Also, this
macro is stored in an Add-In, it is not assigned to any particular
spreadsheet.



All times are GMT +1. The time now is 12:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com