Timestamps in B when data is added in A

I have no what I am doing when I comes to excel VBA programming. What I need is a simple code where if for example A1 is filled in with a value (could be anything) B1 is filled with current time and date. Then the code jumps down one row.

In the module for the worksheet containing the data, add this code:

Please Login or Register  to view this content.

Let me know if you need me to walk you through the details of how to install this code.

1) Copy this code.
2) Right-Click the sheet tab of interest.
3) Select "View Code"
4) Paste the code into the window that appears.
5) Save the file as a macro-enabled .xlsm file.
6) Make changes as needed

Please Login or Register  to view this content.

You do not run this macro. It runs automatically whenever you change a value in column A.

Bernie's code always put the date/time in B1 no matter where the update was made in column A. My impression is that you actually want the date/time in the same row as the new value in column A. Please confirm.

Originally Posted by Bernie Deitrick

Please Login or Register  to view this content.

I am trying to write something in column A, then have the date and time be automatically written in column B. Then go down to the next row.