function getCheckDigit(x) dim a,b,c,a2,a3 a="" b = "" c = "" a2 = "" a3 = "" dim upcARR(10) for i = 0 to 10 upcARR(i) = cint(mid(x,i+1,1)) next a = upcARR(0)+upcARR(2)+upcARR(4)+upcARR(6)+upcARR(8)+upcARR(10) a2 = a*3 a3 = upcARR(1)+upcARR(3)+upcARR(5)+upcARR(7)+upcARR(9) b = a2+a3 c = 300-b getCheckDigit = (cstr(x) & cstr(right(c,1))) end function