[VBA]USE Mobile Data Collection - Scan-IT to Office SCAN BARCODE &INPUT TEXTBOX

[CLAIRE_H]

I used the Excel"Scan-IT to Office app" to scan barcode .
When I use my phone scan barcode,it always input to A1 cell or A2 cell...>A3>A4>A5.....
I need the "barcode number" input to the userform "textbox(A)" not "sheets's cell(A1)"
Like the picture I need the "barcode number(60106-04 -000025)" input to "textbox(A)",but it input to A1 cell
How to revise my vba code? THANKS~

Public Sub show()
 DataForm1.Show
End Sub

Private Sub Form_Load()
    BarcodeScanner.ControlSource = ""
    BarcodeScanner.Locked = True
    BarcodeScanner.TabStop = False
End Sub

Private Sub BarcodeScanner_Scan(ByVal Barcode As String)
    DataForm1.SText.Value = Barcode
End Sub


Private Sub CLear_Click()
   SText.Text = ("")
   NText.Text = ("")
   Ctext.Text = ("")
   Etext.Text = ("")
End Sub


Private Sub NewB_Click()
   LF = Range("A1").End(xlDown).Row + 1

   Cells(LF, 1) = SText.Text
   Cells(LF, 2) = NText.Text
   Cells(LF, 4) = Ctext.Text
   Cells(LF, 5) = Etext.Text
End Sub

 

[Larry Haydn]

Last time I tried using Scan-IT to Office, it targets specific worksheets.
I am not sure if it can transmit the data to a form.

Eventually I just purchase QR Code scanners that stores all the scans, then
download the data (into a spreadsheet) by scanning a specified QR Code
(provided by the scanner manufacturer).

I use this method successfully to:
* Receive raw data into the warehouse
* Transfer raw data to the production facility
* Identify products at the QC station
* Identify pallets when they go into the warehouse
* Shipping the products

For creating barcodes and QR Codes, I use licensed software (TBarcode Office) from TEC-IT.