Help creating buttons for cells

[masonsushi]

Hi guys, I have been reading and found this awesome site. I have a problem. I have a column of items where each cell in the column is the quantity on hand. I wanted to see if there is a way to have 2 small buttons per cell ( + & -) so i can just click it to adjust the quantity up or down in each cell so i don't have to retype the number for each one.

I am fairly new with Excel, with the most basic of skills in it.

Thanks in advance.

Mason

[111StepsAhead]

Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Target.Column = 2 Then
        If Range("A" & Target.Row).Value <> "" Then
            Range("A" & Target.Row).Value = Range("A" & Target.Row).Value + 1
        End If
    ElseIf Target.Column = 3 Then
        If Range("A" & Target.Row).Value <> "" Then
            Range("A" & Target.Row).Value = Range("A" & Target.Row).Value - 1
        End If
    End If
    Cancel = True
End Sub

Put the above code in the worksheet you want it to work on. It assumes in column A you have some number. If you double click column B, the number in A goes up by 1. If you double click column C, the number in A goes down by 1. At least, this will give you a good start on what you want.

[masonsushi]

I still cant seem to get your method to work 111stepsAhead. I tried interring in and it came up with an error message.