Hi,
I am attempting to write an equipment accountability Macro in excel, input is serial number via barcode scanner with carriage return appended. I need 3 user forms: 1 to add/remove equipment by serial number and description (organized by type of equipment), another to sign out multiple equipment items to a specific user, and another to identify any extant equipment that has not been signed back in at the end of the day. I also need a report of activity for a specified timeline (I.E. who has been using said piece of equipment). Just looking to see if there are any examples out there that I can modify before I try to reinvent the wheel. Right now I have a barcode scanner, a standalone computer, and excel 2010. Thanks for any and all help on this!</SPAN>
I am attempting to write an equipment accountability Macro in excel, input is serial number via barcode scanner with carriage return appended. I need 3 user forms: 1 to add/remove equipment by serial number and description (organized by type of equipment), another to sign out multiple equipment items to a specific user, and another to identify any extant equipment that has not been signed back in at the end of the day. I also need a report of activity for a specified timeline (I.E. who has been using said piece of equipment). Just looking to see if there are any examples out there that I can modify before I try to reinvent the wheel. Right now I have a barcode scanner, a standalone computer, and excel 2010. Thanks for any and all help on this!</SPAN>
