|
Posted to microsoft.public.excel.programming
|
|
|
Macro for auto date/time stamp
Ron,
As always, thanks!!!
Bob
"Ron de Bruin" wrote:
Use this Bob
Sheets("Project-1").Range("B7").Value = Format(Now, "dd-mmm-yy hh-mm-ss")
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Bob" wrote in message ...
I am trying to write a macro that I can assign to a button that when pressed,
will insert the current date and time in cell B7 on a sheet named
"Project-1". Please note that the button will be located on a different
sheet other than "Project-1". I would greatly appreciate any help in writing
this macro (I'm just starting to learn VBA). Thanks in advance for any help.
Bob
|