I am a beginner in VBA programming. I use a barcode reader to fill a database "warehouse" via Excel UserForm which has 3 elements - ComboBox1 - TabIndex = 0 this is a field with the name of the goods, TextBox1-TbIndex = 1 this is a quantity, and CommandButton1 - (Confirm ) TabIndex2.
The form works great only after TabIndex2, when the loop should follow to return to TabIndex = 0, to fill the next item, and here I am still clueless.
I used the attached code where the section "Me! ComboBox1.TabIndex = 0"
I found it on the net to move on. This is how the program works for me, but it's a primitive solution and it should definitely look different.
I would like to ask if there is anyone who can help me with this - he would advise.
Thank you very much in advance
Please Login or Register to view this content.