One Cell that controlls spread sheet result button to change simple fomula result

[RAH]

Hello I have a spread sheet with one cell that controls the final result. It is a simple equation but has a big spread sheet with a lot of equations tied to it the master question being =D7/2 How would I create a button that would t give me the result on the same spread sheet =D7/3 am I looking at it in the wrong way as I cannot think my way around it thanking you in advance.

[Pecoflyer]

Could you please be a little more explicit and eventually post a small sample sheet describing your needs?
Thanks

[RAH]

Thanks for your reply I have attached what I think may be the requirement for this to work however you may see it a different way.

[NoSparks]

If you need to change button color use ActiveX buttons,
and what you indicate can be done with just one button.

Private Sub CommandButton3_Click()
' use of only one ActiveX button
With CommandButton3
    If .BackColor = vbYellow Then
        Range("A4").Formula = "=A2/2"
        .Caption = "Current division is by 2"
        .BackColor = vbCyan
    Else
        Range("A4").Formula = "=A2/3"
        .Caption = "Current division is by 3"
        .BackColor = vbYellow
    End If
End With
End Sub

[Pecoflyer]

Moved to the programming forum

[RAH]

Thank you very much for taking the time to solve this for me it works a treat