A problem with the function "NOW"

  • Thread starter Thread starter Matthias Dhondt
  • Start date Start date
M

Matthias Dhondt

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
 
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-:
 
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
 

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

Difference between NOW() and TODAY() 9
Time function =Now formula 4
Difference between NOW() and TODAY() 2
Date function 11
running clock 4
Creating macro 9
Now formula problem 4
Function to Return a Date Value Q 4

Back
Top