Linking an option button? Can it be done?

[TPD]

OK,..Here's the last issue that is hanging me up in this project. This may be a tough one for the average user.

I have an option button on sheet 1. (button 1) I need to have that option button located also in sheet 2, but have it linked to button 1 so that if a person selects that button,...it also shows as being filled in.

I cannot link the option buttons the conventional way, so is there a code I need to have in each button to make them copycats?

td

 

[chicagodiceman]

You can use the same cell link for both sheets as long as there are the same number of option buttons. Link 3 option buttons on Sheet1 & Sheet 2 to A1 and you'll see that they both change together.