there's a type of barcode that is very easy to use: code 39. There are many
free fonts out on the internet.

http://www.bizfonts.com/free/

for code 39 you need to add the "*" character to the number (or A-Z
character) you want to get into the code.

if you have a code in A2, and you want the barcode in a1
you would type in a1

="*" & trim(A2) & "*"

and you need to set A1 to the code39 font

hope that helps!

"Jon" wrote:

Hello group,

Wonder if someone can help.

I'm attempting to create a sheet of barcodes. I've found some barcode
fonts and a VB script which when used together produce results that
work, I.e. valid barcodes.

The process is thus: I use this script to input a 12 digit number, when
I press "generate" the script turns my 12 digits into a string of
characters. I then paste this string of characters into an excel cell
and format it using the barcode font. The result is a barcode which when
sized up to 48 and printed works on my barcode scanner.

What I want to do is to be able to utilised this script somehow in excel
but I have no idea how to do this.

Ideally What I want to do is take the contents of cell A2, put it
through this script and dump the output into cell A1.

Is this possible?
--
Regards
Jon