Time Stamp each time a there is a cell entry

Hi all,


I've used the =NOW() function but it applies only to any changes in the whole document.

WHat if I want to to know the time a guest arrived every time I "marked"the attence in excel? I would like to preserve the arrival time of all guest.

Does anyone knows how?

Thanks

Originally Posted by pjoaquin

The following code will insert the current time in the active cell:

Sub TimeStamp()
    Application.SendKeys ("^+;{ENTER}")
End Sub

You can adjust this to be triggered by a command button, a worksheet change event, a checkbox changing state, etc. and point the SendKeys to a specific cell if you wish.

wow a really usefull code but how about if we want to include date on it or "date" only??

thx in advance

Originally Posted by pjoaquin

The following code will insert the current time in the active cell:

Sub TimeStamp()
    Application.SendKeys ("^+;{ENTER}")
End Sub

You can adjust this to be triggered by a command button, a worksheet change event, a checkbox changing state, etc. and point the SendKeys to a specific cell if you wish.

Hi!Am still a bit of an idiot when it comes to coding,so say if I enter a guest attendance in cell A1. When the value in cell A1 >=1, then I need to fill cell B1 with the time stamp.

How may I insert the wonderful code that you've suggested?

Originally Posted by pjoaquin

iluvtorrent,

Mud's code (link in his post above) provides a nice way of doing it, but for a 'quick-and-dirty' method like my SendKeys post, you could use:

Application.SendKeys ("^;{ENTER}")

To enter just the current date.

Even in the Excel worksheet you can do this, you don't need code unless you want to automate it:

In any cell, press CTRL + ; (CTRL+SEMI-COLON) and it will insert today's date as static (won't change if you open the sheet tomorrow)

and in any cell, press CTRL + SHIFT + ; (CTRL+SHIFT+SEMI-COLON) and it will insert the current time as static.

Mud - thanks for the follow-up.

Thank you guys! I apologize for overlooking that thread.