| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date-time stamp | Excel Discussion (Misc queries) | |||
| Auto Stamp Date | Excel Discussion (Misc queries) | |||
| how do i auto insert a date and time stamp | Excel Discussion (Misc queries) | |||
| Date/time Stamp? | Excel Programming | |||
| Date/Time Stamp Macro Button Problem | Excel Programming | |||
Hybrid Mode
