Macro for auto date/time stamp
 

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

Macro for auto date/time stamp
 

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

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