Buttons & Macros

[Vytfla]

I'm pretty much a novice at Excel, so bear with me while I try to explain this in the easiest way I think is possible. I'm trying to have fields that, when a specific button is clicked, display numbers (or even pictures if that is possible).

Say (for example) a1:a3 say strength, health, and magic, respectively, and I have three buttons over to the side- warrior, rogue, mage. I want b1:b3 to show the stats of the respective class when I click the appropriate buttons (so if I clicked mage, b1 would be 9, b2 = 5, and b3 = 30). How would I do something like that? I know how to create buttons and assign macros to them, but I don't know how to do the specific thing I want.

 

[Warship]

Assigned to Mage Button

Sub MageButton()
    Range("B1") = 9
    Range("B2") = 5
    Range("B3") = 30
End Sub

 

[stnkynts]

For mage. Assign to ActiveX button. You can tailor the others as needed. Experiment with the record macro feature.

Private Sub CommandButton1_Click()
 
'for mage
Range("B1").Value = "9"
Range("B2").Value = "5"
Range("B3").Value = "30"
    
End Sub

 

[Vytfla]

If I have a 10 buttons, that when clicked, will change the same cells; how can I write a function that does that without having to create 10 macros?

 

[teatimecrumpet]

I would suggest making a dropdown using data validation.

and then playing around with this function using named ranges:
<CODE>=SUMIFS(INDIRECT($C$21),Sales_Per,B24,Product,$C$19,Period,$C$20)</CODE>
<CODE></CODE>
<CODE>You could even forgo the dropdown and just type the specific class exactly as it is defined in your data range.</CODE>
<CODE></CODE>

 

[Vytfla]

I would suggest making a dropdown using data validation.

and then playing around with this function using named ranges:
<CODE>=SUMIFS(INDIRECT($C$21),Sales_Per,B24,Product,$C$19,Period,$C$20)</CODE>
<CODE></CODE>
<CODE>You could even forgo the dropdown and just type the specific class exactly as it is defined in your data range.</CODE>
<CODE></CODE>

Thanks for replying. I got some help from a different forum.