| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
to run a command in a cell
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 ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to run a command in a cell
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 ? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to run a command in a cell
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 ? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to run a command in a cell
Hi again ;-)
it does work but it changes the field A1 but i want it to a cell that i want. I click f.e. on A47 and click the button and then date&time appears in A47 "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 ? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to run a command in a cell
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 ? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to run a command in a cell
Try
Sub Macro1() Activecell = now End Sub If this post helps click Yes --------------- Jacob Skaria "Steven Van Laethem" wrote: Hi again ;-) it does work but it changes the field A1 but i want it to a cell that i want. I click f.e. on A47 and click the button and then date&time appears in A47 "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 ? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to run a command in a cell
That is working ! You are great.
Any chance that i can introduce that in a single cell So i click A47 and that the date&time comes automatically "Jacob Skaria" wrote: Try Sub Macro1() Activecell = now End Sub If this post helps click Yes --------------- Jacob Skaria "Steven Van Laethem" wrote: Hi again ;-) it does work but it changes the field A1 but i want it to a cell that i want. I click f.e. on A47 and click the button and then date&time appears in A47 "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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to run a command from a cell | Excel Worksheet Functions | |||
| Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
| Locate a cell, based on a criteria, then use the 'Cell' command... | Excel Discussion (Misc queries) | |||
| in vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell? | Excel Worksheet Functions | |||
| VBA Command to Look at cell in an If statement | New Users to Excel | |||
Linear Mode
