I have a question on implementing this. I am trying to make a checkout/checkin system to track when locks are checked out or in. I have used a VBA userform to make a form for inserting the values for which lock, where it was used, and who removed or returned it. I would like to make the time checked out and time checked in columns timestamp when information is entered. I tried to follow your walkthrough, but have run into issues. I'm having the time columns reference the technician columns so that the time only fills in when a technician name is entered via the form. since I have more than a single technician, I need the ability for multiple values in that column to trigger the macro. I tried using =not (isblank) so that any information entered would make it trigger the timestamp, but it isn't doing anything. I also tried reversing the arguments, so that if = isblank, timestamp "", else timestamp = now(), but that also updates all previous entries. what would be the best way to do that?
This was very helpful thank you!
I have a question on implementing this. I am trying to make a checkout/checkin system to track when locks are checked out or in. I have used a VBA userform to make a form for inserting the values for which lock, where it was used, and who removed or returned it. I would like to make the time checked out and time checked in columns timestamp when information is entered. I tried to follow your walkthrough, but have run into issues. I'm having the time columns reference the technician columns so that the time only fills in when a technician name is entered via the form. since I have more than a single technician, I need the ability for multiple values in that column to trigger the macro. I tried using =not (isblank) so that any information entered would make it trigger the timestamp, but it isn't doing anything. I also tried reversing the arguments, so that if = isblank, timestamp "", else timestamp = now(), but that also updates all previous entries. what would be the best way to do that?