Possible to Connect Multiple Option Buttons (Form Control) On Several Worksheets

[trikky]

I have a two option buttons (form control) located on three different worksheets in the same workbook. They are:

• English
• French

They are connected to a macro that - if English is selected, hides rows that are in French and unhides any hidden rows that are in English. This is done on all three worksheets at the same time. I'm sure you can figure out what happens when French is selected.

However, there is no impact to the option buttons on the remaining worksheets. In other words, if English has been selected on worksheet1, the option that could be selected on worksheet2 could be French.

What I'm wanting to do is tie the option buttons together so that in addition to hiding/unhiding the appropriate rows via that macro, each of the matching option buttons on each worksheet is changed to match the one that is selected. In other words, if a user selects English on worksheet1, the selected value for the option buttons on the remaining worksheets will change to English, and of course if they select French the buttons French buttons on each worksheet will be selected.

Thanks for your help.

 

[Haluk]

Hi;

You can set the "Cell Link" property of the each Option Button items in a "Group Box" item to refer to the same cell. So that, you can achieve your goal.

You can download a sample file from the link below.

https://drive.google.com/open?id=1yCs6-WNLL7I7iSCaEU_m2ryPpUVOPGuU