I need to record movement of stock.
When I click the + Button, I need to subtract 1 from the inventory column and add 1 to the correct location.
In this forum I found the following code that allows me to write an "X" in the cell, but I can't figure out how to add1 and subtract1 istead.
Could you please help me out with this?
Thanks in advance!
Leo
When I click the + Button, I need to subtract 1 from the inventory column and add 1 to the correct location.
In this forum I found the following code that allows me to write an "X" in the cell, but I can't figure out how to add1 and subtract1 istead.
Public Sub Button_Click()
With ActiveSheet.Buttons(Application.Caller)
Cells(.TopLeftCell.Row, .BottomRightCell.Column + 3).Value = "X"
End With
End Sub
Could you please help me out with this?
Thanks in advance!
Leo