I viewed your tutotial on
Automatically Timestamp Data Entries in ExcelLooks like i got it to work now, great code!!! thanks. One thing, how do you code it when you delete the date it deletes the input time and update time as well
I viewed your tutotial on
Automatically Timestamp Data Entries in ExcelLooks like i got it to work now, great code!!! thanks. One thing, how do you code it when you delete the date it deletes the input time and update time as well
Thanks, I'm glad it works for you :)
To clear the cells, you just check for the cell that was changed again and see if it is now empty and then set the value of the date/time cell to ""
I haven't seen the timestamp code in a while but I believe that the setup for doing this is already in the macro and that you can follow the pattern in the tutorial to update it for your needs. If not, post a sample file thta shows what you're working with.
You don't code to "delete the date it deletes" because that would defeat the objective of having a time stamp at all. Instead, when you come to a situation where there is already a time stamp you must decide what you want to do.
The choice is dictated by your workflow. You might even want to allow a change made the same day but not if it's done at another time. I sometimes have projects where only the last row may be changed but not one that was created earlier.
To modify existing code to accommodate such wishes it's necessary to see the code, as Don has already said, and to know your exact plan, I want to add.