Storing information into adjacent cell when an update is made

**ZMBER** · 01-28-2011, 02:43 PM

]I am trying to store data that has been previously computed in Column C to Column D when C is updated:

eg

Column C....
1/25/2011

Column C is then changed: and Column D will store:
1/27/2011 1/25/2011

thank you for your help I have tried using this which I found on this forum but it gives me the date in another column and I cannot get rid of it without making the code unfunctional. I am new to VB so any help would be appreciated.

Please Login or Register  to view this content.

**JBeaucaire** · 01-28-2011, 04:09 PM

By "updated" I assume you mean someone is physically changing the date in column C, and you want the old date that was there to appear next to it in column D. If correct, then:

Please Login or Register  to view this content.

**ZMBER** · 01-28-2011, 05:07 PM

Thank you the only issue I am having now is that if the value is updated to the same date it is not being captured in column D.

Other than that thank you JBeaucaire you solved my problem

**JBeaucaire** · 01-29-2011, 03:58 AM

I specifically added a test to NOT put the same date in twice, that seems redundantly redundant.

5 Points if you can look a the code and spot the part that compares the old value to the new value... find that and take it out and you get 10 points.

**JBeaucaire** · 02-01-2011, 12:43 AM

Did you figure it out?

**ZMBER** · 02-25-2011, 07:24 PM

JBeaucaire,

For some reason it stooped working. I found the redundancy, but now the date I get in D is 1/0/1900 regardless of what is in C. I should probably clarify C isn't manually entered i have another VB that automates the date