CTRL A in a 128 barcode

[FidgetSS]

Is there a way to convert CTRL A in excel so that the output is a 128 bar code that is printable in excel?

 

[Smitty]

Welcome to the Board!

You're really not giving a whole lot to go on. Do you want to reassign CTRL+A to a code shortcut? If so I'd consider using an unreserved shortcut, otherwise CTRL+A won't work.

There are free barcode fonts you can use to create barcodes from a string: http://www.barcodesinc.com/free-barcode-font/

If you post back with more details it'll help.

 

[FidgetSS]

Welcome to the Board!

You're really not giving a whole lot to go on. Do you want to reassign CTRL+A to a code shortcut? If so I'd consider using an unreserved shortcut, otherwise CTRL+A won't work.

There are free barcode fonts you can use to create barcodes from a string: http://www.barcodesinc.com/free-barcode-font/

If you post back with more details it'll help.

What i am trying to do is convert the command CTRL A into a scan-able bar code so that instead of hitting CTRL and A on a motorola Hand Held computer i want to scan it with the laser scanner instead

 

[Smitty]

Wouldn't that be part of the scanner settings?

 

[diddi]

ctrl A is ascii character 1. so you need to use chr(1) in your string

 

[diddi]

are you implementing the code from scratch? just wondering cos i did one a while ago in Code128. much better than a lot of others

 

[FidgetSS]

so would i do something like

(1) in a1 and in b1 =("*"&A1&"*") the * are start and end strings for the Hand Held to know when to start and to end

I have a code128 font installed BTW B1 would be that font

 

[diddi]

theres more to it than that. you have to calculate the checksumn etc or the code wont scan. its not just a font change.

so if you where trying to render "0923433"<ctrl>A
you would the string would be

mybarstring="0923433" & chr(1)

then get the checksum and starting code and render the barcode

 

[alvalee327]

Is there a way to convert CTRL A in excel so that the output is a 128 bar code that is printable in excel?

Have you achieved this? I checked the Code 128 barcode encodable data and found that CTRL A is not in the scope.
I want to attach the picture but I do not know how.