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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Time Stamp Data Entry 2

Status
Not open for further replies.

TriRyche

Technical User
Apr 1, 2004
42
0
0
US
I am trying to create a module for an Excel sheet that will automatically date and time stamp manual data entries, either in an adjacent cell or (preferably) in a note for the cell.
I know barely enough c++ to be dangerous, was proficient with BASIC in the 80's, and can grasp the syntax in the VBA editor. I am currently teaching myself VBA, but do not want to reinvent the wheel.
It would be greatly appreciated if someone will point me in the right direction.
(or at least let me know if I'm in over my head!!).
Thanks
 
Thanks for the thread, but I think I'm still missing something.
Starting with a new Excel wb:
Shift F11,
I select ThisWorkbook
Insert Module
Enter the code.
Save File
But it's not working.
 
I don't think you put the code into a new module; add the code to the worksheet_change event.
 
Thanks so much!!
This keep me busy for a while!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top