I need help to create an Inventory sheet with a running balance and use a barcode scanner.

Hi

I personally have no idea which macro events your scanner will activate so cannot write a macro to run automatically as you describe.

What I can work with however is if your scanner stores numbers into a Sheet Called "Scanned"
Then when you activate sheet "snapohb" your macro will run.

When and if you can tell us if the Change event works then we can upgrade to that.

For now right click on the sheetname "snapohb" at the bottom of excel and select view code

Paste this code into the module that opens and close it.

Try scanning something and see it it triggers a macro

Right Click on the Sheet Name

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "Change Event"
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox "Selection Change Event"
End Sub