Worksheet_change inquiry

[MrKremrik]

Hi all

How would I have the worksheet_change event enter the date a cell was changed into the adjacent column? For example, if a1 = "Yes", b1 = "2012-08-06".

Thanks much!

 

[Joe4]

Are you trying to add this Worksheet_Change VBA code to all the workbooks previously created without it?
Is that the current issue at hand?

 

[MrKremrik]

I think I was just overcomplicating it... I went with just a simple if statement and some other simple work arounds to make it easier. What I was trying to do was have a macro clean up a report, and somehow engage that worksheet_change macro to add the date in. But I just decided to use the if statement to make things easier. And spend less of you time... Sorry about that!
Thanks for all the help!