Auto print from barcode scanner macro

Hi,

Situation: I have a barcode scanner hooked up to a computer running excel and a label printer. When I scan a barcode (which contains a part number) it looks up the description in the label template. I then have to manually hit print to print the label.

What I want to happen is for the label to print automatically after the part number has been scanned into the cell to automate the process. I need a macro to run automatically and so far I have not been successful and I was hoping that somebody could help with what I require.

Thanks!

You haven't provided a lot of information, however this should be quite easy, but it would help to have more info.

I assume from your post that all you do is scan, then press print. So if that is the case, all you need to do is add this code into the module for the sheet that needs to be printed

Please Login or Register  to view this content.

However be aware, that this will print when anything changes on the sheet in question. To make it less of a blunt instrument, I would need to know more about the spreadsheet. eg what is the cell name the captures the bar code?

Please Login or Register  to view this content.

If you change the word "myCell in the code above, with the cell address that captures the bar code, then it will only print when that cell changes.

Hi i know it is long long long time post .
but i don't think him still trying on in.
but i have actual same case with him.
i was try the first code you give. so i need lock some of cell too reduce the human error.
What if my cell was D3 cell how should i do ? is it just i change the myCell to D3 or i change the D3 to name myCell
thanks