Scanning barcodes in a dialog box to check duplicates
 

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

Scanning barcodes in a dialog box to check duplicates
 

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



On Sat, 3 Apr 2004 01:56:13 -0800, "Bernard"
wrote:

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