Scanning barcodes into VBA InputBox issues

[daffyduck1970]

Long time listener, first time poster. I have a barcode scanner that will scan barcodes properly (anywhere from 3-30 characters long) and enter that data correctly in a cell. Now when I create a simple VBA InputBox and scan the barcode, I get about 65% of what I need in the spreadsheet. I've tried different variations of the InputBox, but I still do not get all of my data. I manually scan into a cell and boom, all the data is there. Is this a VBA issue? Scanner issue? My code issue? Am I pulling an ID10T?

Sub Input1()
Dim AddName As String
AddName = InputBox("Scan Your Name Here", "Add Name")
Range("A1").Value = AddName
End Sub

 

[bobsan42]

I have faced no major issues scanning barcodes.
Although I have never used InputBox for this. I have scanned in a cell or a textbox on a userform.
Normally the problems come from the communication with the scanner and it's settings.
Normally it worked best for me when:
- data is passed simulating keystrokes (slowest but most reliable)
- scanner does not try to resolve duplicates
- scan is initiated manually (e.g. only scan when a button is pressed), not automatic scan of anything anytime
- the scanner is a real scanner - not a cell phone camera and software simulation of a scanner

65% of what - 65% of the scanned code or 65% of all codes you scan? Can you give an example? Is it always the same 65%?
Is it possible something in the code to simulate the pressing of an enter key? Do you have spaces or tabs or something too special for a barcode. Especially if simulating keystrokes.
I believe avoiding spaces and special characters in the barcode may improve the results.

For the sake of debugging - write AddName to more than 1 cell, or make sure A1 is not the active cell.