Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Insert Time after Data entry into Excel

Status
Not open for further replies.
Mar 2, 2006
8
GB
Hi All,

I need some of your invaluable help.

I need some vba to insert the current time (shown on PC) to work in excel.

EG When data is selected in a validation list in Column D the current PC time is inserted into Column K in the corresponding row.

So I really need some code to run after the event to get the PC time and paste said time into another cell.

Many Thanks for your help.
 
This is covered in faq707-1657, How to Add a DateStamp in Excel.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top