slave1spectre
New Member
- Joined
- Nov 4, 2019
- Messages
- 11
<a href="https://fhexcelphotos.shutterfly.com/pictures/9" target="_blank">https://fhexcelphotos.shutterfly.com/pictures/9
https://fhexcelphotos.shutterfly.com/pictures/10
Hi All,
Please bear with me as I am not a programmer and therefore aren't fully competent with the terminology or functions.
PROJECT: I am in the process of trying to simplify our lead testing program with a large healthcare organization.
CURRENT PROCESS: Blank spreadsheet…scan a barcode that is attached to a wearable lead…barcode value is recorded and we scan the next item. This process provides no immediate or post testing validation. Validation is performed manually and isnt conducive to time management but with over 3000 leads to test and limited time to complete it isnt possible to do so on the fly.
FUTURE STATE: Spreadsheet with listing of current inventory…scan barcode through a user form…program auto compares against inventory, records scanned barcode, places an X marker in an adjacent cell to designate which units have been tested, records test date, and the preset test location. Ive already built the user form to preselect the location, date, and barcode textbox to scan into. Date of inspection is set through a DT Picker control. Im using a textbox instead of a cmd button in an attempt to keep the process automated instead of having to hit an enter button after each scan.
REQUESTING ASSISTANCE WITH: Writing the code to have the program auto-compare a scanned barcode against the current inventory and record a marker indicating that it has been tested. It will also auto-fill the preset values from the DT Picker and location boxes. Have attached two links above showing...1. #10 Snapshot of the UI where the user would preset the test location, date, and box to scan in the barcode. 2. #9 Snapshot of the excel form where data will be auto generated within the blue colored cells and compared against the values in column E.
https://fhexcelphotos.shutterfly.com/pictures/10
Hi All,
Please bear with me as I am not a programmer and therefore aren't fully competent with the terminology or functions.
PROJECT: I am in the process of trying to simplify our lead testing program with a large healthcare organization.
CURRENT PROCESS: Blank spreadsheet…scan a barcode that is attached to a wearable lead…barcode value is recorded and we scan the next item. This process provides no immediate or post testing validation. Validation is performed manually and isnt conducive to time management but with over 3000 leads to test and limited time to complete it isnt possible to do so on the fly.
FUTURE STATE: Spreadsheet with listing of current inventory…scan barcode through a user form…program auto compares against inventory, records scanned barcode, places an X marker in an adjacent cell to designate which units have been tested, records test date, and the preset test location. Ive already built the user form to preselect the location, date, and barcode textbox to scan into. Date of inspection is set through a DT Picker control. Im using a textbox instead of a cmd button in an attempt to keep the process automated instead of having to hit an enter button after each scan.
REQUESTING ASSISTANCE WITH: Writing the code to have the program auto-compare a scanned barcode against the current inventory and record a marker indicating that it has been tested. It will also auto-fill the preset values from the DT Picker and location boxes. Have attached two links above showing...1. #10 Snapshot of the UI where the user would preset the test location, date, and box to scan in the barcode. 2. #9 Snapshot of the excel form where data will be auto generated within the blue colored cells and compared against the values in column E.