Scan Barcode...compare against inventory...place X in cell when matched...automated

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.
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Cross posted https://www.excelforum.com/excel-pr...y-place-x-in-cell-when-matched-automated.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,885
Messages
6,175,186
Members
452,615
Latest member
bogeys2birdies

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top