| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A problem with the function "NOW"
Hi all,
We made a macro, to show the current time in the cell "A1", we used the function Now()-Today() When you adapt something in Excel, the time in cell "A1" will automatically be changed in the current time. What do we have to change in the macro, that the time don't adapt anymore? greeting Matthias |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
A problem with the function "NOW"
The easiest way to put the current time into a cell so that it doesn't update
is to select the cell and press Ctrl-Shift-: "Matthias Dhondt" wrote: Hi all, We made a macro, to show the current time in the cell "A1", we used the function Now()-Today() When you adapt something in Excel, the time in cell "A1" will automatically be changed in the current time. What do we have to change in the macro, that the time don't adapt anymore? greeting Matthias |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
A problem with the function "NOW"
If you want to put current time into a cell, use Control Shift Colon.
-- David Biddulph "Matthias Dhondt" wrote in message ... Hi all, We made a macro, to show the current time in the cell "A1", we used the function Now()-Today() When you adapt something in Excel, the time in cell "A1" will automatically be changed in the current time. What do we have to change in the macro, that the time don't adapt anymore? greeting Matthias |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
A problem with the function "NOW"
Post the macro you use to enter the time.
ActiveCell.Value = Format(Now(), "h:mm:ss AM/PM") will enter a static time. Perhaps your macro employs event code which updates the time when something changes. Gord Dibben MS Excel MVP On Thu, 13 Sep 2007 12:48:21 +0200, "Matthias Dhondt" wrote: Hi all, We made a macro, to show the current time in the cell "A1", we used the function Now()-Today() When you adapt something in Excel, the time in cell "A1" will automatically be changed in the current time. What do we have to change in the macro, that the time don't adapt anymore? greeting Matthias |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Linear Mode
