knatebaker
02-03-2017, 11:33 AM
Hey all,
So, I've come up with this code, which lets me select a cell, hit the button, and then the selected cell produces the date/time stamp.
--------------------
Sub MyTimeStamp()
Dim DT
'
' MyTimeStamp Macro
'
' Keyboard Shortcut: Ctrl+t
'
DT = Format(Now, "mm/dd/yyyy hh:mm:ss AM/PM")
ActiveCell.Select
Selection.NumberFormat = "mm/dd/yyyy hh:mm AM/PM"
ActiveCell.Value = DT
End Sub
-------------------
What I want it to do is produce that Date/Time Stamp to a specific cell without needing to select it, and the targeted cell would be based off of the current day. Here is what I have on my current spreadsheet:
18242 18243
So, what I want it to do, is I hit the button next to "Kevin" on the Dashboard tab, and it input a "X" or just a date/time stamp into the cell under the column for Kevin by the calendar date it was hit.
Help please!?
Nate
So, I've come up with this code, which lets me select a cell, hit the button, and then the selected cell produces the date/time stamp.
--------------------
Sub MyTimeStamp()
Dim DT
'
' MyTimeStamp Macro
'
' Keyboard Shortcut: Ctrl+t
'
DT = Format(Now, "mm/dd/yyyy hh:mm:ss AM/PM")
ActiveCell.Select
Selection.NumberFormat = "mm/dd/yyyy hh:mm AM/PM"
ActiveCell.Value = DT
End Sub
-------------------
What I want it to do is produce that Date/Time Stamp to a specific cell without needing to select it, and the targeted cell would be based off of the current day. Here is what I have on my current spreadsheet:
18242 18243
So, what I want it to do, is I hit the button next to "Kevin" on the Dashboard tab, and it input a "X" or just a date/time stamp into the cell under the column for Kevin by the calendar date it was hit.
Help please!?
Nate