Simulate Shift+Tab in Excel for Barcodes

Would like to know if there is a way to enter Shift+Tab into a cell, so that a 3 of 9 barcode can be created? Attached is a spreadsheet where the apparent ASCII codes (Char) were entered...but as can be seen, it doesn't produce a clean barcode.  Is there another solution?
Barcode-Test-Shift-Tab.xlsx
Cook09Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

fanpagesCommented:
Sorry, what do you expect to happen when [SHIFT]+[TAB] is used?

Q_28935515
Perhaps you can mock-up what your expectation is in another attachment.
Cook09Author Commented:
It is not apparent if one doesn't have a barcode font installed. The attached file has an image of each barcode, when the 3of9 font is installed.  The expectation is to have C5(6) and D5(6) look like B5(6)
Barcode-Test-Shift-Tab.xlsx
byundtMechanical EngineerCommented:
The 3 of 9 font on my computer (IDAutomationHC39M) does not have barcode-like glyphs for every ASCII code. I suspect the same thing is true for the font you are using.

To see the glyphs available in your font, please change the font for cell A1 in the attached workbook, then click the command button.
Typebook.xlsm
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

DansDadUKCommented:
The standard Code 39 ("3 of 9") repertoire defines 44 characters: 26 upper-case alphabetics, 10 digits, space character, stop/start character, 6 punctuation symbols.
It does not include any control-code characters.

The extended Code 39 repertoire adds lower-case alphabetic characters, additional punctuation symbols, and control-code characters - but you'd require a font which provides glyphs for all of these extra characters.

But (for a valid Code 39 bar-code) these additional characters have to be encoded as two characters; for example:

o; should be encoded as +O/Z
t<HT>y should be encoded as +T$I+Y

See https://en.wikipedia.org/wiki/Code_39 for a description & longer explanation.

Note also that horizontal tab (commonly referred to as Tab or <Tab> or <HT>) is a control-code character (so it is present in the extended ASCII repertoire).
But Shift is not a control-code character; it is a modifier which affects the interpretation of the following key; as such, it is not represented by a character in the extended-ASCII repertoire (or any standard repertoire, as far as I'm aware).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cook09Author Commented:
Thanks for the information and spreadsheet...they really provided some insight. Looks like another option may be needed. Appreciate you assistance with this.
Cook09
DansDadUKCommented:
To correct an error in my previous post; where I stated:

"you'd require a font which provides glyphs for all of these extra characters"

This not true, since the extended repertoire uses the same font characters as the non-extended mode, but encodes all of the additional characters (and some of the original punctuation ones as well) using pairs of characters from the standard repertoire.

To use Code 39 extended, you'd have to be able to switch the scanner into extended mode, since there is no way to determine the mode from the bar-code - you'll just get different values depending on whether the scanner is assuming standard mode or extended mode.
Cook09Author Commented:
DansDadUK
Thanks for the additional information.  Now all I have to do is figure out how to use the Symbol LS2208 in extended mode, and how that would be different than regular mode. However, from what I understand, even if figured out, I still would not be able to the Shift key in conjunction with the Tab key....is that correct?

Cook09
DansDadUKCommented:
>> ... I still would not be able to the Shift key in conjunction with the Tab key....is that correct?

The Shift key is not associated with a character code - it merely modifies the action of other keys (e.g. the 'A' key normally produces the lower-cases character 'a', whilst Shift+A produces upper-case 'A (assuming that Caps-Lock is not set).

So all that you can 'record' is the character associated with the 'Shift + key' combination.
The 'Tab' key generates the <HT> horizontal tab control-code character; I've no idea what 'Shift + Tab' will produce (if anything different).
DansDadUKCommented:
I set up a small test using NotePad:

Typed in the characters "abcde" followed by <Tab>, then "pqrst" and <Enter> (for a new line)
Repeated this, but using <Shift> + <Tab> instead.
Saved the file (as a .txt text file).
Examined the file with a hexadecimal editor; this shows that both <Tab> and <Shift> + <Tab> generated the <HT> horizontal tab control-code character (the character with decimal code 9, or hexadecimal 09).

So it seems that the <Shift> key has no effect when paired with the <Tab> key, although this may of course be application-specific?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.