Thanks Gary for your smart idea. since this will be used for many excel
files, because each project will have a seperate file, Can we save the macro
in an excel file but can be run in any other project excel files when we open
it?

Thanks for your advice

Frank


"Gary''s Student" wrote:

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