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
Barcode-Test-Shift-Tab.xlsx
Last Comment
ASKER
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
Barcode-Test-Shift-Tab.xlsx
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks for the information and spreadsheet...they really provided some insight. Looks like another option may be needed. Appreciate you assistance with this.
Cook09
Cook09
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.
"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.
ASKER
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
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
>> ... 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).
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).
I set up a small test using NotePad:
So it seems that the <Shift> key has no effect when paired with the <Tab> key, although this may of course be application-specific?
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?
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Perhaps you can mock-up what your expectation is in another attachment.