The concept:

I am trying to use a cmd button to increment the value of a cell. The two cells adjacent to the left have a negative value of -5 and -10 and the opposite on the right hand side so that you have a scale e.g 10, 15, 20, 25, 30

I need a button to the left of the range which decreases the values by 5 and a button to the right of the range that increases the values by 5.

My method:

I have an IF statement in the central cell that makes the cell display a value based on the value of cell AC6 like so:

=IF($AC$5="10%","15%",IF($AC$5="12%","15%",IF($AC$5="15%","15%",IF($AC$5="20%","20%",IF($AC$5="25%","25%",IF($AC$5="30%","30%",IF($AC$5="35%","35%",IF($AC$5="40%","40%",IF(AC5="CHOOSE %","15%","15%")))))))))

As you can see the minimum value of the central cell is 15% but it increments by 5 if cell AC6 is 20% or above.

I have programmed a cmd button as follows:

Private Sub CommandButton1_Click()
Sheets("Pricing new").Range("ac5").Value = Sheets("Pricing new").Range("ac5").Value + 5
End Sub

This works, however the cell with the IF statement does not recognise the change in cell AC6 when the button is pressed and therefore does not update the formula.

Any help would be gratefully appreciated

Stretch