call userform

[rapitorres]

hi. im currently working on a little inventory. little by little things are getting possible thanks for the help of our member here. you know who you are. and Im very Thankful to you guys

here I'am again asking for help. again.


so i have a sheet here. as you can see theres a column name barcode.
it so happen that I'm really using a barcode scanner to scan things and get details from encoded items
and then type in the quantity in the "IN" column or header.

what Id like to happen is every time I scan an item in barcode column, a userform will pop out and gonna ask for the quantity to be enter
and it will pass out to "IN" column

now Ive tried different codes
Private Sub TextBox1_Change()
Range("@Barcode").Value = TextBox1.Value
UserForm1.Show
End Sub

and nothing happens.
hope you can help me with this.

 

[rapitorres]

I did wonder if Barcode scanners worked the same as entering values manually. I have never used a Barcode scanner so I have no answer sorry.

nah no worries you help me alot though. maybe its a setting in my barcode. still searching

 

[My Aswer Is This]

nah no worries you help me alot though. maybe its a setting in my barcode. still searching

Let me know if you figure it out.

 

[rapitorres]

Let me know if you figure it out.

Hi!

its working now. what i did is i just factory reset my barcode scanner
and disabled Suffix CR LF. it has something to do with the movement or tabbing after scan. i don't know how is that fix.
but somehow it worked.

thanks man.

 

[My Aswer Is This]

Hi!

its working now. what i did is i just factory reset my barcode scanner
and disabled Suffix CR LF. it has something to do with the movement or tabbing after scan. i don't know how is that fix.
but somehow it worked.

thanks man.

Glad to hear that.