Check out this
http://www.youtube.com/watch?v=cbDbA83DbhI
Sub Macro1()
Range("A1") = Now
End Sub
=NOW() is a formula. The above macro will insert the current date and time
to cell A1. If you are looking to insert a formula try
Sub Macro1()
Range("A1") = "=NOW()"
End Sub
If this post helps click Yes
---------------
Jacob Skaria
"Steven Van Laethem" wrote:
Did all but doesn't work. I use Excel 2007 is your solution also for this
version ?
The command to have the system date&time is =now()
must it be the same your code ?
"Jacob Skaria" wrote:
Set the Security level to low/medium in (Tools|Macro|Security). From workbook
launch VBE using short-key Alt+F11. From menu 'Insert' a module and paste the
below code. Save. Get back to Workbook.
Sub Macro1()
Range("A1") = Now
End Sub
--From ToolbarsDrawingToolbarAutoShapesBasic Shapes select any shape you
like. say ("Bevel") and place that in your worksheet.
--Right click the shapeAssign Macro and select the macro to be assigned
--Now try Button click
If this post helps click Yes
---------------
Jacob Skaria
"Steven Van Laethem" wrote:
Hello,
I want to run a command -- =Now()
in a cell.
I want it configured as a button ( in a cell) so when i press that
button/cell that automaticayly it takes the system date and tim.
Who can help me ?