INPUTING a text string and a function in one cell?

R

R3Jar

I would like to create a mcro that will execute with a hot key combo that will
put the text string
" an. mach." and the function Now() to indicate that I received an answering
machine at the date and time of the function Now(). Does anybody know what I
have to do to accomplish this? Thanks a billion for any advice.
 
R

Ron de Bruin

Try this

Sub test()
ActiveCell.Value = "an. mach." & Format(Now, "dd-mm-yy h-mm-ss")
End Sub

Assign a shortcut to this macro
 
Top