Forum Discussion
Solved
Time Macros
I am trying to create a time sheet kinda workbook. I am wanting to set it up that when you click a button it will enter the current time. I need multiple buttons to do this to enter breaks, lunch, et...
Instead of setting the formula of a cell to "=NOW()", set its value to Now. For example:
Sub SetTime() Range("D2").Value = Now End Sub.
Please provide the code of the macros, or preferably, attach a copy of the workbook without sensitive data.