Radio Buttons Selecting Other Radio Buttons

Is there a way to have radio buttons (Option Buttons) select other radio buttons on another work sheet? I have a catalog where a person can select a computer system on the first work sheet and is then able to customize the system throughout the various other worksheets. However, I am wanting the radio button for a system to atomatically select the radio buttons of the hardware items that come with that selected system.

Please help me! This is my last hurdul and then my catalog will be essentially complete!

Dave,

Thanks for the feed back. However, this will not work as I have each radio button already linked to a cell which in turn are used by a reciept worksheet. I was hoping there would be a way to use VB. My file is fairly large 12MB in excel formate and 7MB in zip so I cannot attach
If you have any other ideas that would be great!

Again thank you

Dave,

Thank you again for your info and research - your AWSOME!

I think I figured out a way to do it however. You gave me the idea when you said link cells As all of my radio buttons are linked to a cell then all I need to do is change that linked cell to either TRUE or FALSE Would you by chance know the code in VB to change a cell in a given worksheet to be either TRUE or FALSE? If so than I can just add that code into:

PHP Code: 

Private Sub BuyViloCon_Click()
   
End Sub 


And have it change items option buttons link cell to be either true or false Once i have that code I will be good to go...
I am going to look in the VB help file provided by Excel to see what I can dig up.
Again thank you Dave!

SWEET! I figured it out

Private Sub BuyViloCon_Click()
   Worksheets("Background").Cells(3, 6).Value = True
   
End Sub

Again thank you so much Dave!