Greetings ,

I was hoping to simplify the macro that I am using, as I have over 50 buttons that I use. It is rather time consuming every time I have to add a new product.

Below I have attached the code.

Ideally if a command button could simply be placed within a cell, where by, the adjacent cell would be affected. If this something like this would work it would save a lot of time writing macros.

Any help would be appreciated.

I am currently using this code for a command button.
Private Sub CommandButton1_Click()
Range("C4").Value = Range("C4").Value + 1


End Sub
As well as this one

Private Sub CommandButton2_Click()
Range("C4").Value = Range("C4").Value - 1

End Sub
Terrance