Scanning barcodes in a dialog box to check duplicates

[Bernard]

Hello,
I'm currently using this formula:
"=IF(LEN(G1)>9,CONCATENATE(VLOOKUP(VALUE((LEFT
(G1,2))),$AA$1:$AB$25,2),(MID(G1,3,6)),"-",(RIGHT
(G1,2))),CONCATENATE(VLOOKUP(VALUE((LEFT
(G1,2))),$AA$1:$AB$25,2),(MID(G1,3,6)),"-",(RIGHT(G1,1))))"
to scan barcodes into a cell, that converts to i.e.
A123456-7. It works well, and I have conditional format to
colorize any duplicate value, if any (formula is= IF
(COUNTIF($1:$65536,A1)>1,TRUE,FALSE). My problem is that
this process is registering the new value and is thus
incrementing my file
I would like now to scan these barcodes into a dialog box
that will then also colorize an existing value, but
without registering the value entered into the dialog box

Any idea?
Thanks
Bernard

 

[Thomas Lutz]

The following URL points to a sample bar code inventory type program
for Excel that uses a dialog box to input bar code data and then
perform a lookup in a worksheet to find data that already exists.

http://www.taltech.com/downloads/Inventory.exe


For more bar code tips, tricks and tools, please visit www.taltech.com