Macro to Enter Static Date and Time into Cell

[Alex20850]

I am looking for a macro that will enter the current date and time in one cell so that it will not change from the time entered.

I see that I can enter Ctrl+; [Space] Ctrl+Shift+; but I am looking for a way to assign that to one key combination.

 

[Yongle]

One way
- assign a shortcut to this

Sub FixNow()
    ActiveCell.Value = Now
End Sub

 

[Alex20850]

One way
- assign a shortcut to this

Sub FixNow()
    ActiveCell.Value = Now
End Sub

Great, thanks!