Date&Time Stamp issue

[Pops2580]

Am in the process of creating a referral log, using drop down lists that records information data. On particular column of cells am seeking a formula that will allow me to date&time (stamp) when the referral is started and then time&date (stamp) when completed, using the computer clock.

Many Thanks

Pops

[alansidman]

Use this code:

Sub DateToday()
ActiveCell.Value = Now

End Sub

You could attach it to a command button. It will put the current date and time in your active cell.

[Pops2580]

Many thanks for the code. It has worked a treat.

Pops

[alansidman]

Glad to have helped.