Hi, I have a userform for users to input data via a barcode scanner. There is this barcode which I would like to separate into 3 textboxes, and the information in the barcode looks like this: #03-106,A,1
I want to split the data into Combobox1: #03-106, Combobox2: A, Combobox3: 1
Can anyone help me with this?
A little confused. You refer to three textboxes and three comboboxes.
With the code below, If you scan the bar code in TextBox1, the code will automatically split it into TextBox1, TextBox2, and TextBox3.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hi Alphafrog, thanks for the reply. My mistake, sorry about that, it should be comboboxes. Would it work the same if its comboboxes? I tried changing the codes to comboboxes, and the result I got was Combobox1: #03-1061, Combobox2:A, Combobox3: empty
Did I do something wrong?
It might not work with a bar code scanner. I don't have one to test with.
As a test, can you copy the text #03-106,A,1 then select Combobox1 and paste it (Ctrl+V)
If that works and the scanner doesn't, we'll have to figure something else out.
It should work if you put the code in a command button instead of the Combobox1_Change event, or maybe put it in the Combobox1_Exit event.
This would split the scanner text when you exit the combobox.
Please Login or Register to view this content.
Last edited by AlphaFrog; 02-15-2017 at 10:33 PM.
Thanks Alphafrog! it's working now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks