from help

Now()
Numbers to the right of the decimal point in the serial number represent the
time; numbers to the left represent the date. For example, the serial number
..5 represents the time 12:00 noon

in a formula it will always recalculate so you need to tie to an event.

Easiest would be to viewtoolbarscontrol toolbox - selexct a command button
and add this to your spreadsheet. tie the code to clicking the box instead
of the cell and tie the results to the cell.


"KimR.Hammel" wrote:

How can I get Excel to automatically input the current time when a cell is
selected? Also, upon selecting the cell again, the time must be removed.