Excel VBA using barcode scanner

[Vishnu_k_madhu]

Hi friends
I am trying to create a excel VBA file for my inventory purposes. I have already created the form for issue vouchers and all. I want to include the barcode scanner usage into my userform by assigning each barcode reader to each department. So if any barcode will scans, I want to get the barcode details and also about from which department that barcode device triggered. Please advise me the solution for the above problem.

 

[CsJHUN]

Since this post is old, i guess you found solution.

Here how i did this:
- Made a form with one inputbox (here comes the barcode data, manually or via barcode reader)
- write an inputbox_afterupdate event which find the relevant data
--after this the user can decide if move this data (stock, whatever the barcode is identified) out of warehouse, or read other one.
---later added a partial removal, the stuff stayed on the registered place, with previously registered data, but changed the quantitiy