Selecting a radio button on another sheet

**Einstahb** · 10-24-2011, 09:56 PM

Hi,

I have a macro that references a radio button named "WaiverPrintingONOB" on another worksheet named "Administrator". It doesn't seem to reference it properly though because when the value is true the msgbox still appears.

If Sheets("Administrator").OptionButtons("WaiverPrintingONOB").Value = True Then
FR_or_ENForm.Show
Else
MsgBox "It works!", vbDefaultButton1, "Test"
End If

Can anyone help me reference the button properly?

Thanks

**6StringJazzer** · 10-24-2011, 10:05 PM

Are you using an ActiveX radio button? (It would help to attach your workbook.) I would have done this, but I'm not sure what your problem is:

 
If Sheets("Administrator").WaiverPrintingONOB Then
   FR_or_ENForm.Show
Else
   MsgBox "It works!", vbDefaultButton1, "Test"
End If

**Einstahb** · 10-25-2011, 07:51 PM

Hi,

Thanks for the reply. The code you provided still doesn't seem to work. I've attached a file with the function.The radio button is on the "administrator" page. The command button that runs the macro is on the "Waiver" page.

Joel

**6StringJazzer** · 10-25-2011, 08:22 PM

You are using the older "form" controls. My advice was for ActiveX controls.

A form control radio button has a value of 1 if it's on, and -4146 if it's off (don't ask me). So you could go back to your original code, checking for those values.

**Einstahb** · 10-26-2011, 02:56 PM

Thanks for your help. With the proper value, the code works perfectly!

If Sheets("Administrator").OptionButtons("WaiverPrintingONOB").Value = 1 Then
FR_or_ENForm.Show
Else
MsgBox "It works!", vbDefaultButton1, "Test"
End If