Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time calculations for Scheduled Time vs. Actual Time Worked | Excel Discussion (Misc queries) | |||
straight time, time and a half, and double time | Excel Discussion (Misc queries) | |||
Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions |