New to Excel VBA: update cell when row changes

[mateo107]

Hello All,

I've done some extensive VBA work in Access, but I now need some VBA help in Excel.

Here's what I'd like to do...
When a workbook is opened, popup asking for a "Enter your First and Last Name", which will be stored as a String >> this I can handle.

What i need help is...
Whenever a row is updated with data, I would like to add the shortdate and ":" and then [Name String] to row "L". I'm trying to add a custom tracking log to see who is updating rows of data in my excel spreadsheet.

Any ideas?
Thanks!

PS: I'm using Excel 2000 / 2003

[EDIT]:
After a little more thought... I'd like to track changes in this manner...
I have columns A-K that I'd like to monitor. If ANY of these fields are updated, THEN write the ShortDate & ":" & [String'd NAME] into the corresponding row on Sheet3 titled "Modifications"

For example:

if 'Jane Smith' updates B1632 on 2/23/06, on the sheet titled "Modifications", i'd like to see: 02/23/06:Jane Smith on row 1623 (In Column A is fine)

if 'John Doe' updates G and K 22 on 2/24/06, on the sheet titled "Modifications, i'd like to see: 02/24/06:John Doe on row 22 (In column A is okay)

Does this make sense? I guess the question is multi-parted.