Assign the shortcut CNTRL-d to the following macro:

Sub frank()
Dim s As String
s = "Finished dated "
ActiveCell.Value = s & Format(Now(), "dd mmm yyyy")
End Sub


--
Gary''s Student - gsnu200728


"Frank Situmorang" wrote:

hello:

In lotus we can create a macro to ask us in the middle of the process to
copy to which range. The macro in lotus is like {?} then we sreach the cursor
downward the cell B for example, and then we can copy it to that range.

I want to make in excel similar to it, I want if we hit control D, iin cell
d5 , it will automatically Type "Finished dated 12 Jun 2007"" for today. To
morrow I will put in cell d20 the same word with the tomorrow 's date.

Can anybody teach me how to do it?, The wording of the VBA could be
"Finished" & To day()? or NOW()

Thanks in advance

Frank