One Radio Button To Trigger Another Radio Button On Different Excel Sheet (Same Workbook)

[rameezl17]

Hi All,

I have a radio button on sheet1 module 1 called (Sec1No). this is the code :

Sub Sec1No
MsgBox "blah"
End Sub

Then I have a radio button on sheet2 module2.

Is it possible that when the user clicks on the first radio button sheet 1 to then automatically check the radio button on sheet 2?

Thank you for your help!

 

[Yongle]

Syntax:

Application.Run ([COLOR=#000080]"[/COLOR][COLOR=#ff0000]'[/COLOR]My other workbook name.xlsm[COLOR=#ff0000]'[/COLOR]!MyProcedureName[COLOR=#000080]"[/COLOR])

The other workbook MUST be open
If the code is in a sheet module then it must be included too

Sub callBlah()
Application.Run ("'[COLOR=#ff0000]Blah.xlsm[/COLOR]'![COLOR=#000080]Sheet1[/COLOR].[B]OptionButton1_Click[/B]")
End Sub

Runs procedure OptionButton1_Click which is in sheet1's module in workbook Blah.xlsm

 

[rameezl17]

Hey Yongle,

So both radio buttons are in the same workbook, just different sheet.

Im a little lost.

so in sheet 1 module 1 which is the first radio button, I would reference the radio button that is in sheet 2, right?

 

[Yongle]

With everything in the same workbook:

If the VBA that you want to run is in the sheet module for sheet1

Call Sheet1.Sec1No

If the VBA that you want to run is in the sheet module for sheet2

Call Sheet2.Sec1No

If the VBA that you want to run is in a standard module

Call Sec1No

 

[Jon Peltier]

Are there sets of option buttons (so select from multiple options), or just one? If there's just one (to check or uncheck, or indicate yes or no), it's customary to use a checkbox.

If there are multiple (matching) option buttons on both sheets, you could simply use the same link cell. Changing the link cell value with one set of buttons will cause the other set of buttons to update their state.

If there is a checkbox on each sheet, again use a single link cell. Checking one box will change the link cell, and that will change the other checkbox.