how do i record changes i make to a cell?
 

I am wanting to use a drop box to add info to a cell (serial number) and then
once i change that serial number to another from the drop box I want to
record it in say a list box to show wich serial numbers has been used. Thia
way i can keep a running track of the use of the serailized items.