Auto populating the date when a value is changed

%3CLINGO-SUB%20id%3D%22lingo-sub-3101598%22%20slang%3D%22en-US%22%3EAuto%20populating%20the%20date%20when%20a%20value%20is%20changed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3101598%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHoping%20someone%20can%20help.%20I%20have%20a%20excel%20sheet%20where%20column%20x%20has%20a%20drop%20down%20option%20of%20listing%20%22Open%22%20or%20%22Closed.%22%20Whenever%20a%20new%20row%20is%20added%2C%20I%20need%20to%20mark%20it%20as%20open%20but%20eventually%20once%20the%20project%20is%20finished%2C%20I%20need%20to%20mark%20it%20as%20%22Closed%22%20using%20the%20drop%20down%20in%20column%20x.%20I%20have%20another%20column%2C%20D%2C%20that%20lists%20the%20closed%20date.%20Is%20it%20possible%20to%20have%20the%20date%20automatically%20populate%20in%20column%20d%20when%20column%20x%20is%20marked%20as%20%22Closed%22%3F%20I've%20found%20codes%20that%20will%20populate%20a%20date%20when%20a%20value%20is%20entered%20in%20the%20cell%20but%20none%20where%20the%20date%20is%20populated%20when%20the%20value%20is%20changed.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3101598%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3101782%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20populating%20the%20date%20when%20a%20value%20is%20changed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3101782%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1294008%22%20target%3D%22_blank%22%3E%40corh1234%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20what%20you%20want%20to%20do%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3101965%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20populating%20the%20date%20when%20a%20value%20is%20changed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3101965%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1174419%22%20target%3D%22_blank%22%3E%40Quadruple_Pawn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20that's%20it%20exactly!!!%20If%20I%20have%20a%20table%20and%20I%20add%20more%20than%2025%20rows%2C%20will%20it%20still%20work%3F%20Thanks%20so%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hoping someone can help. I have a excel sheet where column x has a drop down option of listing "Open" or "Closed." Whenever a new row is added, I need to mark it as open but eventually once the project is finished, I need to mark it as "Closed" using the drop down in column x. I have another column, D, that lists the closed date. Is it possible to have the date automatically populate in column d when column x is marked as "Closed"? I've found codes that will populate a date when a value is entered in the cell but none where the date is populated when the value is changed.

3 Replies

@corh1234 

Is this what you want to do?

@Quadruple_Pawn 

 

Yes, that's it exactly!!! If I have a table and I add more than 25 rows, will it still work? Thanks so much!

@corh1234 

Set rngBereich = Range("W2:W25")

 

It works depending on the range in the VBA code. The example works for rows 2 to 25. But you can easily change the range to e.g. "W2:W200" and it works for rows 2 to 200.