View Single Post
  #1   Report Post  
Jon
 
Posts: n/a
Default Using a VB Script for barcodes - new to this

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