When closing excel remember radio button choice

[Blue_Wings]

Hi there,

How can i save the radio button choice and calculate a sum?
If i press the radio button the sum its ok, but if i close the excel workbook and open it again, the correct radion button is selected but doesnt make the sum requested in the function.

I had made so far this: (maybe i have to pass the boolean as a parameter to the workbook_open, but i dont know how to do it, and i am confused if the things have to be private or public)

This code is on: ThisWorkbook

Public Sub Workbook_Open()

If Selection = True Then Call Sheet1.OptionButtonA_Click Else Call Sheet1.OptionButtonB_Click

End Sub

.
This code is on: Sheet1

Dim PaymentA As Range
Dim PaymentB As Range

Dim BasePayment As Range
Dim TotalPayment As Integer

Dim Selection As Boolean

Public Sub OptionButtonA_Click()


Set PaymentA = Sheet1.Range("H29")
Set BasePayment = Sheet1.Range("H30")
TotalPayment = PaymentA + BasePayment
Sheet1.Range("F34").Value = TotalPayment

Selection = True

End Sub

Public Sub OptionButtonB_Click()

Set PaymentB = Sheet1.Range("H31")
Set BasePayment = Sheet1.Range("H32")
TotalPayment = PaymentB + BasePayment
Sheet1.Range("F34").Value = TotalPayment

Selection = False

End Sub

But it doesnt work when i close the excel and then open it again, as i was explaning,

Can anyone help me with this problem?
Thanks