Thread: [Solved] Button & Macro Help
View Single Post
 
Old 01-07-2017, 08:27 AM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

You could do something as simple as, place three buttons on your worksheet and add three separate codes to your VBA. Assign the buttons to the codes below.

Change the Range to wherever you want the percentage.

Code:
Sub Push_Button_1()
    Range("A1").Value = "1.1"
End Sub
Code:
Sub Push_Button_2()
    Range("A1").Value = "1.2"
End Sub
Code:
Sub Push_Button_3()
    Range("A1").Value = "1.25"
End Sub
Reply With Quote