If macro help needed.

[slm7678]

hello all,

long time no post. i am trying to write some code for a command button.
what i have are two option buttons and one command button.
what i would like for it to do would be this:

if option button 1 is true then take A2*10 when command button is pressed

if option button 2 is true then take A2*20 when command button is pressed.
(these are simplified examples but i think i can work the rest in if i get a good starting place.)

im not sure how to proceed. im pretty sure i want an if then statement but i leave it in your capable hands.

TIA
Shannon

 

[TommyGun]

If OptionButton1 Then
    Range("B2") = Range("A2") * 10
ElseIf OptionButton2 Then
    Range("B2") = Range("A2") * 20
Else
    Range("B2") = Range("A2")
End If

 

[slm7678]

Works like a champ. Thank you very much for you help

Shannon