Calling variable from radio button in userform to a module

[raghavanhr]

Hi Experts,

I have a workbook with a User Form with two radio buttons (a,b), an 'OK' Command Button and a 'Cancel Command' Button.

On Sheet1("Form") I have a command button that loads the User Form.

I also have a module in VBA, where I would like to write a subroutine (called by Clicking the OK button on my User Form) that contains the value of the selected radio button. This should take a value from my User Form depending upon which of the two Radio Buttons clicked by the user, Company provided Ticket for Radio button 1 and Self Ticket for Radio BUtton 2, return this to the value to a cell address.

I am struggling to figure out how to pass and receive values between the radio button selected and would really appreciate some advice!

Thank you for reading,

 

[DanteAmor]

It is not necessary to go through a module to write to a cell depending on the selected option.

Private Sub CommandButton1_Click()
  If OptionButton1 = True Then Range("A3").Value = "Some data"
  If OptionButton2 = True Then Range("B3").Value = "whatever"
End Sub

But if you want it to work in a module, it is not necessary to pass the data either, you just have to read the data referring to the userform:

In userform:

Private Sub CommandButton1_Click()
  Call macro_in_module
End Sub

In a module:

Sub macro_in_module()
  If UserForm1.OptionButton1 = True Then Range("A3").Value = "Some data"
  If UserForm1.OptionButton2 = True Then Range("B3").Value = "whatever"
End Sub