Macro for auto date/time stamp

G

Guest

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
 
R

Ron de Bruin

Use this Bob

Sheets("Project-1").Range("B7").Value = Format(Now, "dd-mmm-yy hh-mm-ss")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro to date stamp to the right of the macro command button 4
Time/Date Stamp 3
Unable to assign macros to a new button in the current worksheet 1
Autosave Macro to specific file location 0
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Macro to create log file 3
Pause in a macro 2

Top