Excel: date stamp when cell changed

Hi, hope someone can help, very simply I want to capture the date and time that a cell is changed. So if the value in cell A2 is changed, then cell B2 date stamps with the current time; similiarly if cell A3 is changed, then cell B3 date stamps... Tried looking at previous threads, I'm a bit confused by one that seems to work with a personal sub? Please can someone help, I'm no expert in macros but if there's a simple one I can use, or a formula based solution, I'd be very grateful, thanks, Richard

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of June 14, 2009.

For more resources for Microsoft Excel