VBA for 3 OptionButtons

[lisa_25]

Hi - this is probably a pretty simple one, I'm trying to write some VBA for 3 Option Buttons. The first two lines work but the third one doesn't. I'm pretty new to writing VBA.

Private Sub OptionButton1_Change()
If OptionButton1.Value = True Then Sheet36.Range("C2").Value = 10
If OptionButton2.Value = True Then Sheet36.Range("C2").Value = 20
If OptionButton2.Value = True Then Sheet36.Range("C2").Value = 30
End Sub

 

[lisa_25]

Sorry, this is the code:

Private Sub OptionButton1_Change()
If OptionButton1.Value = True Then Sheet36.Range("C2").Value = 10
If OptionButton2.Value = True Then Sheet36.Range("C2").Value = 20
If OptionButton3.Value = True Then Sheet36.Range("C2").Value = 30
End Sub

 

[lisa_25]

I'm sorry, i need to delete this thread and I can't see where it should be deleted Please ignore.