Adding date on input in cell

[Megashira]

Hello,

I'm quiet new to VBA and I hope one of the smart people here has a (simple) sollution for my problem. I'm making a macro which automaticly will add the current date to a cell in the same row whenever the value in a nearby cell is changed to a certain value.

Richt now I can change the value in the cells in column D and the macro will add the date of the change in column B. But I also want to add a new line, where a change in column F to a certain value will add the current date in cell I.

Below is my code thus far. Can anyone show me what to do to make this code work?

Thanks in advance

Please Login or Register  to view this content.

[stnkynts]

Maybe this:

Please Login or Register  to view this content.

[Megashira]

Thank you very much Stnkynts. Your solution works